{"text_format":"3","workbook":"xlsx","n_sheets":19,"sheets":["Instructions","Cover","Position","Activities 1","Activities 2","Activities 3","Disclosures","Sch. 1","Sch. 2","Sch. 3","Sch. 4","Sch. 5","Sch. 6","Sch. 7","Sch. 8","Accounting_Review","Accounting_Review_2","Adjustments","IMP_Interest"],"not_rendered":{"macros":1,"external_links":1,"defined_names":77,"comments":15},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":58,"n_cols":16,"rows_kept":58,"merged":[[11,2,11,9],[24,4,24,9],[27,13,27,14],[28,3,28,4],[28,6,28,7],[30,13,30,14],[35,2,35,9],[35,13,35,14],[57,1,58,9]]}
["Diocese of Metuchen",{"$nulls":8},"Appendix A"]
["Parish Financial Statement & Report Instructions"]
["FYE June 30, 2022"]
[]
[]
[null,"General Instructions"]
[]
[null,"1)","All values should be reported in whole dollars."]
[]
[null,"2)","Statements should be prepared on a full accrual basis of accounting."]
[]
[null,"3)","Begin by working through the Schedules.  As you fill them with data, the accompanying"]
[null,null,"financial statements will be partially completed, as information you enter will automatically"]
[null,null,"be posted to the correct places in the statements.  Within the statements:"]
[]
[null,null,"-","Reference","The column(s) on the right hand side of each document",{"$nulls":4},"®",null,"Reference"]
[{"$nulls":3},"contains links which can be used to move between the schedules and"]
[{"$nulls":3},"their corresponding statements.",{"$nulls":5},"®",null,"Example"]
[]
[null,null,"-","Purple","Indicates that data will populate the cell from a schedule."]
[{"$nulls":3},"The corresponding schedule is listed in the \"Reference\" column."]
[]
[null,null,"-","Green","Indicates that data may be entered manually."]
[]
[null,null,"-","Red Triangle","Indicates that there is information about the cell in a comment,"]
[{"$nulls":3},"which can be viewed by holding your mouse over any cell with a red triangle"]
[{"$nulls":3},"in the upper right hand corner."]
[{"$nulls":13},"Instructions",null,"This is an example of an instructions box, which will"]
[null,null,"-","Instructions",null,"as well as","Note",null," boxes are",{"$nulls":4},"guide you through the essentials of completing each section of the statement."]
[{"$nulls":3},"available in the margins of each page to offer guidance and reminders",{"$nulls":5},"®"]
[{"$nulls":3},"as you complete the statement.",{"$nulls":9},"Note",null,"This is an example of a note box, which will contain"]
[{"$nulls":13},"notes to draw your attention to certain items which have historically been the"]
[null,null,"-",null,"Checkboxes on pages 2 and 3 of the report ask you to indicate",{"$nulls":8},"source of errors in Parishes' reporting."]
[{"$nulls":3},"a response to yes or no questions.  Please check the box to indicate \"yes.\""]
[]
[null,"4)","Please do not submit paper copies of this document.  When the report has been "]
[null,null,"completed and reviewed, print the Cover and gather the appropriate signatures for the  "]
[null,null,"acknowledgements.  This cover, along with any necessary supporting documents, should be"]
[null,null,"scanned and emailed or submitted via mail to:"]
[]
[{"$nulls":3},"The Diocese of Metuchen"]
[{"$nulls":3},"ATTN:  Oscar Montalvo"]
[{"$nulls":3},"146 Metlars Lane"]
[{"$nulls":3},"Piscataway, NJ  08854"]
[]
[null,"5)","Please attach the completed Excel document to an email, and submit it to:"]
[]
[{"$nulls":3},"omontalvo@diometuchen.org"]
[]
[null,null,"If you experience a problem in transmission, please re-submit to:"]
[{"$nulls":3},"dioceseofmetuchen@gmail.com"]
[]
[]
[null,"If you have questions or require guidance while preparing your report, please contact Oscar Montalvo"]
[null,"at (732) 243-4555 or omontalvo@diometuchen.org for assistance."]
[]
[]
[null,"Please submit all documents to the Diocese by August 31, 2022."]

{"sheet":"Cover","index":1,"n_rows":43,"n_cols":20,"rows_kept":43,"merged":[[3,1,3,11],[4,1,4,11],[5,1,5,11],[6,1,6,11],[7,17,7,18],[8,4,8,8],[10,4,10,8],[12,4,12,8],[14,6,14,8],[16,6,16,8],[21,1,21,11],[24,1,24,4],[25,1,25,4],[25,6,25,9],[29,1,29,4],[30,1,30,4],[30,6,30,9],[34,1,34,4],[35,1,35,4],[35,6,35,9],[38,1,38,11],[41,1,41,4],[42,1,42,4],[42,6,42,9]]}
[]
[]
[]
[null,"The Diocese of Metuchen"]
[null,"Parish Financial Statement & Report"]
[]
[null,"FYE June 30, 2022"]
[{"$nulls":15},"Reference",null,"Instructions:",null,"When the financial statements are completed and the"]
[null,null,"Name:",null,"-",{"$nulls":12},"pastor, preparer, and two trustees have reviewed them, please complete the"]
[{"$nulls":17},"green shaded fields, print this cover, and gather the signatures required for"]
[null,null,"Town:",null,"-",{"$nulls":12},"the acknowledgements."]
[]
[null,null,"Federal Tax ID#:",null,"-",{"$nulls":12},"The signed cover should be forwarded to the Diocese by mail or email to the "]
[{"$nulls":17},"address in the instructions tab."]
[{"$nulls":4},"Registered Catholic Families:",null,0,{"$nulls":8},"Disclosures"]
[]
[{"$nulls":4},"Registered Catholics:",null,0]
[]
[]
[]
[]
[null,"I have reviewed the Parish Financial Statement & Report for the fiscal year ending June 30, 2022, and have discussed the Statement and Report with the preparer.  To the best of my knowledge the statements, schedules, and any supporting documents supplied are complete and accurate."]
[]
[]
[]
[null,"Pastor/Administrator Name",{"$nulls":4},"Pastor/Administrator Signature",{"$nulls":4},"Date"]
[]
[]
[]
[]
[null,"Trustee Name",{"$nulls":4},"Trustee Signature",{"$nulls":4},"Date"]
[]
[]
[]
[]
[null,"Trustee Name",{"$nulls":4},"Trustee Signature",{"$nulls":4},"Date"]
[]
[]
[null,"I have prepared the Parish Financial Statement & Report for the fiscal year ending June 30, 2022 in accordance with the basis of accounting as set forth in the instructions, notes, and account descriptions included in this report.  To the best of my knowledge the statements, schedules, and any supporting documents supplied are complete and accurate. Financial Report is due Wednesday, August 31, 2022."]
[]
[]
[]
[null,"Preparer Name",{"$nulls":4},"Preparer Signature",{"$nulls":4},"Date"]

{"sheet":"Position","index":2,"n_rows":52,"n_cols":26,"rows_kept":52,"merged":[[2,1,2,12],[3,1,3,12],[8,20,8,21],[18,20,18,21],[38,20,38,21],[41,20,42,21],[41,22,41,24],[41,25,41,27],[42,22,42,27],[46,20,46,21]]}
[{"$nulls":12},"Page 1"]
[]
[null,"Statement of Financial Position"]
[null,"2022-06-30"]
[]
[]
[{"$nulls":5},"Church &",null,"School &"]
[{"$nulls":5},"Rectory",null,"Convent",null,"Cemetery",null,"Total",null,null,"Reference",null,"Reference",null,"Reference"]
["Current Assets:",{"$nulls":19},"Instructions",null,"This statement reports the balances of the Parish’s"]
[null,100,null,"Cash",null,{"$f":"'Sch. 1'!J26","v":0},null,{"$f":"'Sch. 1'!J46","v":0},null,{"$f":"'Sch. 1'!J58","v":0},null,{"$f":"SUM(F10:J10)","v":0},null,null,"Sch. 1",null,"-",null,"-",null,"assets and liabilities on the last day of the fiscal year. It also reports “Net"]
[null,101,null,"Petty Cash",null,0,null,0,null,0,null,0,null,null,"-",null,"-",null,"-",null,"Assets,” which is calculated as assets less liabilities."]
[null,102,null,"Diocesan Investment Mgmt. Program",null,{"$f":"'Sch. 2'!O25","v":0},null,{"$f":"'Sch. 2'!O49","v":0},null,{"$f":"'Sch. 2'!O66","v":0},null,{"$f":"SUM(F12:J12)","v":0},null,null,"Sch. 2",null,"-",null,"-"]
[null,104,null,"External Investments",null,{"$f":"'Sch. 2'!O24","v":0},null,{"$f":"'Sch. 2'!O48","v":0},null,{"$f":"'Sch. 2'!O65","v":0},null,0,null,null,"Sch. 2",null,"-",null,"-",null,"Fields shaded in purple will populate information directly from their related"]
[null,105,null,"Mortgages & Loans Receivable",null,0,null,0,null,0,null,0,null,null,"-",null,"-",null,"-",null,"schedules (or expense lines in the case of Accumulated Depreciation), which"]
[null,107,null,"Accounts Receivable ",null,0,null,0,null,0,null,0,null,null,"-",null,"-",null,"-",null,"are indicated in the reference columns.  "]
[null,108,null,"Prepaid Expense",null,0,null,0,null,0,null,0,null,null,"-",null,"-",null,"-"]
[null,109,null,"Scrip Inventory",null,0,null,0,null,0,null,{"$f":"SUM(F17:J17)","v":0},null,null,"-",null,"-",null,"-",null,"The remaining line items must be manually entered on the face of the statement."]
[]
["Fixed Assets:",{"$nulls":19},"Note",null,"Negative figures (apart from Accumulated Depreciation)"]
[null,110,null,"Land",null,{"$f":"'Sch. 8'!F21+'Sch. 3'!E14","v":0},null,{"$f":"'Sch. 8'!H21+'Sch. 3'!G14","v":0},null,{"$f":"'Sch. 8'!J21+'Sch. 3'!I14","v":0},null,{"$f":"SUM(F20:J20)","v":0},null,null,"Sch. 8","+","Sch. 3",null,"-",null,"should never be reported on the Statement of Position.  This often results from"]
[null,111,null,"Buildings",null,{"$f":"'Sch. 8'!F22+'Sch. 3'!E26","v":0},null,{"$f":"'Sch. 8'!H22+'Sch. 3'!G26","v":0},null,{"$f":"'Sch. 8'!J22+'Sch. 3'!I26","v":0},null,{"$f":"SUM(F21:J21)","v":0},null,null,"Sch. 8","+","Sch. 3",null,"-",null,"Parishes transferring funds between units (Church, School, Cemetery) and"]
[null,112,null,"Building Improvements",null,{"$f":"'Sch. 8'!F23+'Sch. 3'!E43","v":0},null,{"$f":"'Sch. 8'!H23+'Sch. 3'!G43","v":0},null,{"$f":"'Sch. 8'!J23+'Sch. 3'!I43","v":0},null,{"$f":"SUM(F22:J22)","v":0},null,null,"Sch. 8","+","Sch. 3",null,"-",null,"reporting the transfer on one line."]
[null,113,null,"Vehicles",null,{"$f":"'Sch. 8'!F24+'Sch. 3'!E58","v":0},null,{"$f":"'Sch. 8'!H24+'Sch. 3'!G58","v":0},null,{"$f":"'Sch. 8'!J24+'Sch. 3'!I58","v":0},null,{"$f":"SUM(F23:J23)","v":0},null,null,"Sch. 8","+","Sch. 3",null,"-"]
[null,114,null,"Furniture & Equipment",null,{"$f":"'Sch. 8'!F25+'Sch. 3'!E75","v":0},null,{"$f":"'Sch. 8'!H25+'Sch. 3'!G75","v":0},null,{"$f":"'Sch. 8'!J25+'Sch. 3'!I75","v":0},null,{"$f":"SUM(F24:J24)","v":0},{"$nulls":6},"-",null,"Any funds transferred between units must be set up as loans to be repaid.  The  "]
[{"$nulls":20},"unit making the loan records an asset on Line 105 (Mortgages & Loans"]
["Accumulated Depreciation:",{"$nulls":19},"Receivable), while the unit receiving the loan records a liability on Line 202"]
[null,115,null,"Buildings",null,{"$f":"'Sch. 8'!F28-'Activities 3'!F43-'Sch. 3'!E28","v":0},null,{"$f":"'Sch. 8'!H28-'Activities 3'!H43-'Sch. 3'!G28","v":0},null,{"$f":"'Sch. 8'!J28-'Activities 3'!J43-'Sch. 3'!I28","v":0},null,{"$f":"SUM(F27:J27)","v":0},null,null,"Sch. 8","-","Sch. 3","+","Line 573",null,"(Mortgages & Loans Payable) via Schedule 4."]
[null,116,null,"Building Improvements",null,{"$f":"'Sch. 8'!F29-'Activities 3'!F44-'Sch. 3'!E45","v":0},null,{"$f":"'Sch. 8'!H29-'Activities 3'!H44-'Sch. 3'!G45","v":0},null,{"$f":"'Sch. 8'!J29-'Activities 3'!J44-'Sch. 3'!I45","v":0},null,{"$f":"SUM(F28:J28)","v":0},null,null,"Sch. 8","-","Sch. 3","+","Line 574"]
[null,117,null,"Vehicles",null,{"$f":"'Sch. 8'!F30-'Activities 3'!F45-'Sch. 3'!E60","v":0},null,{"$f":"'Sch. 8'!H30-'Activities 3'!H45-'Sch. 3'!G60","v":0},null,{"$f":"'Sch. 8'!J30-'Activities 3'!J45-'Sch. 3'!I60","v":0},null,{"$f":"SUM(F29:J29)","v":0},null,null,"Sch. 8","-","Sch. 3","+","Line 575"]
[null,118,null,"Furniture & Equipment",null,{"$f":"'Sch. 8'!F31-'Activities 3'!F46-'Sch. 3'!E77","v":0},null,{"$f":"'Sch. 8'!H31-'Activities 3'!H46-'Sch. 3'!G77","v":0},null,{"$f":"'Sch. 8'!J31-'Activities 3'!J46-'Sch. 3'!I77","v":0},null,{"$f":"SUM(F30:J30)","v":0},null,null,"Sch. 8","-","Sch. 3","+","Line 576"]
[]
[]
[{"$nulls":3},"Total Assets:",null,{"$f":"SUM(F10:F32)","v":0},null,{"$f":"SUM(H10:H32)","v":0},null,{"$f":"SUM(J10:J32)","v":0},null,{"$f":"SUM(L10:L32)","v":0},null,null,"-",null,"-",null,"-"]
[]
["Liabilities:"]
[null,200,null,"Accounts Payable",null,{"$f":"'Sch. 5'!E22","v":0},null,{"$f":"'Sch. 5'!G22","v":0},null,0,null,{"$f":"SUM(F36:J36)","v":0},null,null,"Sch. 5",null,"-",null,"-"]
[null,201,null,"Assessments Payable",null,0,null,0,null,0,null,{"$f":"SUM(F37:J37)","v":0},null,null,"-",null,"-",null,"-"]
[null,202,null,"Mortgages & Loans Payable",null,{"$f":"'Sch. 4'!M22","v":0},null,{"$f":"'Sch. 4'!M44","v":0},null,{"$f":"'Sch. 4'!M64","v":0},null,0,null,null,"Sch. 4",null,"-",null,"-"]
[null,203,null,"Diocesan Loans Payable",null,{"$f":"'Sch. 4'!M23","v":0},null,{"$f":"'Sch. 4'!M45","v":0},null,{"$f":"'Sch. 4'!M65","v":0},null,0,null,null,"Sch. 4",null,"-",null,"-",null,"Note",null,"The liability reported on Line 204 (Stipends Payable)"]
[null,204,null,"Stipends Payable",null,0,null,0,null,0,null,0,null,null,"-",null,"-",null,"-",null,"should roughly equal the cash on hand in the Stipend bank account, as reported"]
[null,205,null,"Pension Contribution Payable",null,0,null,0,null,0,null,0,null,null,"-",null,"-",null,"-",null,"for the Church on Line 3 of Schedule 1."]
[null,206,null,"Insurance Premium Payable",null,0,null,0,null,0,null,{"$f":"SUM(F42:J42)","v":0},null,null,"-",null,"-",null,"-",null,{"$f":"IF(ABS((Position!F40-'Sch. 1'!J12))<=99,\"OK\",\"Error\")","v":"OK"},null,{"$f":"\"Line 102 = \"&TEXT(F40,\"$#,##0\")","v":"Line 102 = $0"},null,null,{"$f":"\"Sch. 1, Line 3 = \"&TEXT('Sch. 1'!J12,\"$#,##0\")","v":"Sch. 1, Line 3 = $0"}]
[null,207,null,"Deferred Revenue",null,{"$f":"'Sch. 5'!E41","v":0},null,{"$f":"'Sch. 5'!G41","v":0},null,{"$f":"'Sch. 5'!I41","v":0},null,0,null,null,"Sch. 5",null,"-",null,"-",{"$nulls":3},{"$f":"\"There is a difference of \"&TEXT(ABS(F40-'Sch. 1'!J12),\"$#,##0\")","v":"There is a difference of $0"}]
[null,208,null,"Payroll Liabilities",null,0,null,0,null,0,null,{"$f":"SUM(F44:J44)","v":0},null,null,"-",null,"-",null,"-"]
[null,209,null,"Other Liabilities",null,{"$f":"'Sch. 5'!E60","v":0},null,{"$f":"'Sch. 5'!G60","v":0},null,{"$f":"'Sch. 5'!I60","v":0},null,0,null,null,"Sch. 5",null,"-",null,"-"]
[]
[{"$nulls":20},"Note",null,"The term \"Net Assets\" closely resembles the concept of"]
[{"$nulls":3},"Total Liabilities:",null,{"$f":"SUM(F36:F47)","v":0},null,{"$f":"SUM(H36:H47)","v":0},null,{"$f":"SUM(J36:J47)","v":0},null,{"$f":"SUM(L36:L47)","v":0},null,null,"-",null,"-",null,"-",null,"Equity in a for-profit setting.  Net Assets represents the balance of everything "]
[{"$nulls":20},"owned by (or owed to) the Parish and any obligations the Parish has to third-"]
[null,300,null,"Net Assets:",null,{"$f":"+F33-F48","v":0},null,{"$f":"+H33-H48","v":0},null,{"$f":"+J33-J48","v":0},null,{"$f":"+L33-L48","v":0},null,null,"Disclosures",null,"-",null,"-",null,"parties.  On the Statement of Position, Net Assets = Assets - Liabilities."]
[]
[{"$nulls":3},"Total Liabilities & Net Assets:",null,{"$f":"+F48+F50","v":0},null,{"$f":"+H48+H50","v":0},null,{"$f":"+J48+J50","v":0},null,{"$f":"+L48+L50","v":0},null,null,"-",null,"-",null,"-"]

{"sheet":"Activities 1","index":3,"n_rows":56,"n_cols":22,"rows_kept":56,"merged":[[2,1,2,12],[3,1,3,12],[8,16,8,17],[19,19,19,23],[20,17,20,23],[22,16,22,17],[27,16,27,17],[32,16,32,17],[34,16,35,17],[34,18,35,23],[42,16,42,17],[45,16,46,17],[45,18,45,20],[45,21,45,23],[46,18,46,23],[48,16,48,17]]}
[{"$nulls":12},"Page 2"]
[]
[null,"Statement of Activities"]
[null,"FYE June 30, 2022"]
[]
[]
[{"$nulls":5},"Church &",null,"School &"]
[{"$nulls":5},"Rectory",null,"Convent",null,"Cemetery",null,"Total",null,null,"Reference"]
["Ordinary Revenue:",{"$nulls":15},"Instructions",null,"This statement, which is split into three worksheets,"]
[null,400,null,"Weekend Collections",null,0,null,0,null,0,null,{"$f":"SUM(F10:J10)","v":0},null,null,"-",null,"reports the revenues earned and expenses incurred by the Parish.  It also"]
[null,401,null,"Holy Day Collections",null,0,null,0,null,0,null,{"$f":"SUM(F11:J11)","v":0},null,null,"-",null,"calculates the \"Change in Net Assets\" (formerly called \"Revenue Over/(Under)"]
[null,402,null,"Christmas Collection",null,0,null,0,null,0,null,{"$f":"SUM(F12:J12)","v":0},null,null,"-",null,"Expense\") as a result of the Parish's operations for the year."]
[null,403,null,"Easter Collection",null,0,null,0,null,0,null,{"$f":"SUM(F13:J13)","v":0},null,null,"-"]
[{"$nulls":16},"Fields shaded in purple will populate information directly from their related"]
[{"$nulls":16},"schedules, which are indicated in the reference column.  "]
[{"$nulls":3},"Collection Revenue (subtotal):",null,{"$f":"SUM(F10:F15)","v":0},null,{"$f":"SUM(H10:H15)","v":0},null,{"$f":"SUM(J10:J15)","v":0},null,{"$f":"SUM(L10:L15)","v":0},null,null,"-"]
[{"$nulls":16},"The remaining line items must be manually entered on the face of the statement."]
[null,405,null,"Gifts & Donations (Non-Development)",null,0,null,0,null,0,null,{"$f":"SUM(F18:J18)","v":0},null,null,"-"]
[null,406,null,"Fund Raising (Net)",null,0,null,0,null,0,null,{"$f":"SUM(F19:J19)","v":0},null,null,"-",null,null,"Is the Rental Income reported on Line 410 the result of a multi-year"]
[null,410,null,"Rental Income",null,0,null,0,null,0,null,{"$f":"SUM(F20:J20)","v":0},null,null,"-",null,false,"lease?",{"$f":"IF(L20=0,\"N/A\",IF(Q20=FALSE,\"No\",\"Yes\"))","v":"N/A"},{"$f":"IF(AND(L20<>0,Q20=TRUE),\"Please provide the lessee's name below:\",\"\")","v":""}]
[null,411,null,"Offerings",null,0,null,0,{"$nulls":3},{"$f":"SUM(F21:J21)","v":0},null,null,"-"]
[null,418,null,"Dividends & Interest (non-DOM IMP)",null,0,null,0,null,0,null,{"$f":"SUM(F22:J22)","v":0},null,null,"-"]
[{"$nulls":16},"Note",null,"Except where indicated, Parishes should not net revenues"]
[{"$nulls":16},"and expenses in any account on the Statement of Activities.  The exceptions to this"]
[{"$nulls":3},"Other Ordinary Rev. (subtotal):",null,{"$f":"SUM(F18:F23)","v":0},null,{"$f":"SUM(H18:H23)","v":0},null,{"$f":"SUM(J18:J23)","v":0},null,{"$f":"SUM(L18:L23)","v":0},null,null,"-",null,"rule are Lines 406 (Fundraising), 570 (Food Service Operations), and 571 (Student "]
[{"$nulls":16},"Activities).  "]
[{"$nulls":3},"Total Ordinary Revenue:",null,{"$f":"F16+F25","v":0},null,{"$f":"H16+H25","v":0},null,{"$f":"J16+J25","v":0},null,{"$f":"L16+L25","v":0},null,null,"-"]
[{"$nulls":16},"Note",null,"Line 418 (Dividends & Interest (non-DOM IMP)) should"]
["Extraordinary Revenue:",{"$nulls":15},"include any interest earned on bank deposits from \"Schedule 1 - Cash\" plus any"]
[null,420,null,"IMP Interest Income",null,{"$f":"'Sch. 2'!I25","v":0},null,{"$f":"'Sch. 2'!I49","v":0},null,{"$f":"'Sch. 2'!I66","v":0},null,{"$f":"SUM(F30:J30)","v":0},null,null,"Sch. 2",null,"interest and/or dividends earned on external investments from \"Schedule 2 -"]
[null,424,null,"Diocesan Grants",null,0,null,0,null,0,null,0,null,null,"-",null,"Investments\"."]
[null,425,null,"Authorized Collections",null,0,null,0,null,0,null,0,null,null,"-"]
[null,426,null,"Unrealized Gain/(Loss)",null,{"$f":"'Sch. 2'!K24","v":0},null,{"$f":"'Sch. 2'!K48","v":0},null,{"$f":"'Sch. 2'!K65","v":0},null,0,null,null,"Sch. 2",null,"Note",null,"Any revenues reported on Line 425 (Authorized Collections)"]
[null,427,null,"Realized Gain/(Loss)",null,{"$f":"'Sch. 2'!M24","v":0},null,{"$f":"'Sch. 2'!M48","v":0},null,{"$f":"'Sch. 2'!M65","v":0},null,0,null,null,"Sch. 2",null,"must be accompanied by written approval from the Bishop's Office."]
[null,428,null,"Religious Education Fees",null,0,null,0,null,0,null,0,null,null,"-",null,{"$f":"IF(('Activities 1'!F32=0),\"OK\",\"Backup Required\")","v":"OK"},null,{"$f":"IF(F32=0,\"No Authorized Collections have been reported.\",\"Please submit written approval for Authorized Collections.\")","v":"No Authorized Collections have been reported."}]
[null,429,null,"Diocesan Collections",null,{"$f":"'Sch. 6'!H18","v":0},null,0,null,0,null,{"$f":"SUM(F36:J36)","v":0},null,null,"Sch. 6"]
[null,431,null,"National & Missionary Appeals",null,{"$f":"'Sch. 6'!H41","v":0},null,0,null,0,null,0,null,null,"Sch. 6"]
[null,432,null,"Bishop's Appeal Rebate",null,0,null,0,null,0,null,0,null,null,"-"]
[null,433,null,"Bequests (Inheritances)",null,0,null,0,null,0,null,0,null,null,"-"]
[null,440,null,"School Tuition & Fees",null,0,null,0,null,0,null,0,null,null,"-"]
[null,441,null,"Preschool Tuition & Fees",null,0,null,0,null,0,null,0,null,null,"-"]
[null,442,null,"Other School Fees",null,0,null,0,null,0,null,0,null,null,"-"]
[null,443,null,"Pupil Transportation Fees",null,0,null,0,null,0,null,0,null,null,"-",null,"Note",null,"The revenue reported by the School on Line 444 (School"]
[null,444,null,"School Subsidy from Parish",null,0,null,0,null,0,null,0,null,null,"Line 540",null,"Subsidy from Parish) must agree with the expense reported by the Church on "]
[null,447,null,"School Subsidy from DOM Assessment",null,0,null,0,null,0,null,0,null,null,"-",null,"Line 540 (Parish School Subsidy)."]
[null,450,null,"Cemetery Sales",null,0,null,0,null,0,null,0,null,null,"-",null,{"$f":"IF(('Activities 1'!H44='Activities 3'!F10),\"OK\",\"Error\")","v":"OK"},null,{"$f":"\"Line 444 = \"&TEXT(H44,\"$#,##0\")","v":"Line 444 = $0"},null,null,{"$f":"\"Line 540 = \"&TEXT('Activities 3'!F10,\"$#,##0\")","v":"Line 540 = $0"}]
[null,451,null,"Mausoleum Sales",null,0,null,0,null,0,null,0,null,null,"-",{"$nulls":3},{"$f":"\"There is a difference of \"&TEXT(ABS(H44-'Activities 3'!F10),\"$#,##0\")&\".\"","v":"There is a difference of $0."}]
[null,452,null,"Burial Income",null,0,null,0,null,0,null,0,null,null,"-"]
[null,453,null,"Annual & Perpetual Care",null,0,null,0,null,0,null,0,null,null,"-",null,"Note",null,"Line 454 (Other Revenue) has historically been an account"]
[null,454,null,"Other Revenue",null,{"$f":"'Sch. 7'!E27","v":0},null,{"$f":"'Sch. 7'!G27","v":0},null,{"$f":"'Sch. 7'!I27","v":0},null,0,null,null,"Sch. 7",null,"where many Parishes have made reporting errors.  For a detailed discussion of"]
[null,460,null,"Development Income",null,0,null,0,null,0,null,0,null,null,"-",null,"this account, see \"Schedule 7 - Other Statement of Activity Accounts\"."]
[]
[]
[{"$nulls":3},"Extraordinary Revenue (subtotal):",null,{"$f":"SUM(F30:F52)","v":0},null,{"$f":"SUM(H30:H52)","v":0},null,{"$f":"SUM(J30:J52)","v":0},null,{"$f":"SUM(L30:L52)","v":0},null,null,"-"]
[]
[null,475,null,"Total Revenue:",null,{"$f":"F27+F54","v":0},null,{"$f":"H27+H54","v":0},null,{"$f":"J27+J54","v":0},null,{"$f":"L27+L54","v":0},null,null,"-"]

{"sheet":"Activities 2","index":4,"n_rows":55,"n_cols":22,"rows_kept":55,"merged":[[2,1,2,12],[3,1,3,12],[4,1,4,12],[13,16,13,17],[18,16,18,17],[21,16,22,17],[21,18,21,20],[21,21,21,23],[22,18,22,23],[25,20,25,21],[28,16,28,17],[43,16,43,17]]}
[{"$nulls":12},"Page 3"]
[]
[null,"Statement of Activities"]
[null,"FYE June 30, 2022"]
[null,"(continued)"]
[]
[{"$nulls":5},"Church &",null,"School &"]
[{"$nulls":5},"Rectory",null,"Convent",null,"Cemetery",null,"Total",null,null,"Reference"]
["Expenses:"]
[null,500,null,"Salaries: Clergy",null,0,null,0,null,0,null,{"$f":"SUM(F10:J10)","v":0},null,null,"-"]
[null,501,null,"Salaries: Religious",null,0,null,0,null,0,null,{"$f":"SUM(F11:J11)","v":0},null,null,"-"]
[null,"-",null,"Salaries: Lay",{"$nulls":10},"-"]
[null,502,null,"  -  Administrative/Clerical",null,0,null,0,null,0,null,{"$f":"SUM(F13:J13)","v":0},null,null,"-"]
[null,502,null,"  -  Instruction/Teachers",null,0,null,0,null,0,null,0,null,null,"-",null,"Note",null,"Except where indicated, Parishes should not net revenues"]
[null,502,null,"  -  Maintenance/Custodial",null,0,null,0,null,0,null,0,null,null,"-",null,"and expenses in any account on the Statement of Activities.  The exceptions to this"]
[null,502,null,"  -  Musicians/Ministry",null,0,null,0,null,0,null,0,null,null,"-",null,"rule are Lines 406 (Fundraising), 570 (Food Service Operations), and 571 (Student "]
[null,503,null,"Medical Insurance:  Clergy",null,0,null,0,null,0,null,0,null,null,"-",null,"Activities)."]
[null,504,null,"Medical Insurance:  Religious/Lay",null,0,null,0,null,0,null,0,null,null,"-"]
[null,505,null,"Other Employee Benefits",null,0,null,0,null,0,null,0,null,null,"-",null,"Note",null,"Clergy are considered self-employed for Social Security "]
[null,506,null,"Social Security:  Employer Portion",null,0,null,0,null,0,null,0,null,null,"-",null,"purposes.  The Parish must not withhold FICA taxes from priests’ pay, and may not"]
[null,507,null,"Pension:  Clergy",null,0,null,0,null,0,null,0,null,null,"-",null,"pay the employer’s portion of priests’ Social Security expenses."]
[null,508,null,"Lay Benefits",null,0,null,0,null,0,null,0,null,null,"-",null,{"$f":"IF(ABS(L20-(SUM(L13:L16)*0.0765))<1,\"OK\",IF(L20>(SUM(L13:L16)*0.0765),\"Error\",IF((SUM(L13:L16)*0.0765)-L20>=(SUM(L13:L16)*0.0765)*0.25,\"Error\",\"OK\")))","v":"OK"},null,{"$f":"\"Line 502 X 7.65% = \"&TEXT(SUM(L13:L16)*0.0765,\"$#,##0\")&\".\"","v":"Line 502 X 7.65% = $0."},null,null,{"$f":"\"Line 506 = \"&TEXT(L20,\"$#,##0\")","v":"Line 506 = $0"}]
[null,510,null,"Food and Household",null,0,null,0,null,0,null,0,null,null,"-",{"$nulls":3},{"$f":"\"There is a difference of \"&TEXT(ABS((SUM(L13:L16)*0.0765)-L20),\"$#,##0\")&\".\"","v":"There is a difference of $0."}]
[]
[{"$nulls":17},"Has the Parish filed all of the necessary tax documents, including Forms"]
[{"$nulls":3},"Salaries & Benefits (subtotal):",null,{"$f":"SUM(F10:F25)","v":0},null,{"$f":"SUM(H10:H25)","v":0},null,{"$f":"SUM(J10:J25)","v":0},null,{"$f":"SUM(L10:L25)","v":0},null,null,"-",null,false,"W-2 and/or Forms 1099?",null,null,{"$f":"IF(Q26=FALSE,\"No\",\"Yes\")","v":"No"}]
[]
[]
[null,511,null,"Office Supplies",null,0,null,0,null,0,null,{"$f":"SUM(F29:J29)","v":0},null,null,"-",null,"Note",null,"Expenditures on fixed assets which the Parish does not"]
[null,512,null,"Furniture & Equipment < $500",null,0,null,0,null,0,null,0,null,null,"-",null,"wish to capitalize should not be included on \"Schedule 3 - Fixed Assets\", but rather"]
[null,513,null,"Contracted Services - Office Equip.",null,0,null,0,null,0,null,0,null,null,"-",null,"should be reported on the Statement of Activities using the following lines:"]
[null,514,null,"Professional Services",null,0,null,0,null,0,null,0,null,null,"-",null,"-","512 (Furniture & Equipment < $500)"]
[null,515,null,"Telephone",null,0,null,0,null,0,null,0,null,null,"-",null,"-","521 (Repairs & Renovations < $5,000)"]
[null,516,null,"Printing & Stationery",null,0,null,0,null,0,null,0,null,null,"-",null,"-","523 (Maintenance Equipment < $500)"]
[null,517,null,"Postage & Mailing",null,0,null,0,null,0,null,0,null,null,"-"]
[null,518,null,"Bank Charges",null,0,null,0,null,0,null,0,null,null,"-"]
[null,519,null,"Administration Expense",null,0,null,0,null,0,null,0,null,null,"-"]
[]
[]
[{"$nulls":3},"Administration (subtotal):",null,{"$f":"SUM(F29:F38)","v":0},null,{"$f":"SUM(H29:H38)","v":0},null,{"$f":"SUM(J29:J38)","v":0},null,{"$f":"SUM(L29:L38)","v":0},null,null,"-"]
[]
[]
[null,520,null,"Contracted Services",null,0,null,0,null,0,null,{"$f":"SUM(F43:J43)","v":0},null,null,"-"]
[null,521,null,"Repairs & Renovations < $5,000",null,0,null,0,null,0,null,{"$f":"SUM(F44:J44)","v":0},null,null,"-",null,"Note",null,"Parishes should report the total of all insurance premiums"]
[null,522,null,"Maintenance Supplies",null,0,null,0,null,0,null,{"$f":"SUM(F45:J45)","v":0},null,null,"-",null,"billed for the fiscal year including Property & Liability insurance, auto insurance,"]
[null,523,null,"Maintenance Equipment < $500",null,0,null,0,null,0,null,0,null,null,"-",null,"student accident insurance, and special event insurance on Line 524 (Insurance)."]
[null,524,null,"Insurance",null,0,null,0,null,0,null,0,null,null,"-"]
[null,525,null,"Utilities",null,0,null,0,null,0,null,0,null,null,"-",null,"As with all revenues and expenses on the Statement of Activities, Insurance must"]
[null,526,null,"Travel",null,0,null,0,null,0,null,0,null,null,"-",null,"be reported on a full accrual basis.  The entire Property & Liability Insurance"]
[null,527,null,"Cemetery Operations",null,0,null,0,null,0,null,{"$f":"SUM(F50:J50)","v":0},null,null,"-",null,"expense billed for each fiscal year should be reported here regardless of when it is"]
[null,528,null,"Health Services",null,0,null,0,null,0,null,{"$f":"SUM(F51:J51)","v":0},null,null,"-",null,"paid."]
[null,529,null,"Pupil Transportation",null,0,null,0,null,0,null,{"$f":"SUM(F52:J52)","v":0},null,null,"-"]
[]
[]
[{"$nulls":3},"Operations & Maintenance (subtotal):",null,{"$f":"SUM(F43:F53)","v":0},null,{"$f":"SUM(H43:H53)","v":0},null,{"$f":"SUM(J43:J53)","v":0},null,{"$f":"SUM(L43:L53)","v":0},null,null,"-"]

{"sheet":"Activities 3","index":5,"n_rows":53,"n_cols":22,"rows_kept":53,"merged":[[2,1,2,12],[3,1,3,12],[4,1,4,12],[8,16,8,17],[11,16,12,17],[11,18,11,20],[11,21,11,23],[12,18,12,23],[14,16,14,17],[19,16,19,17],[33,16,33,17],[47,16,47,17]]}
[{"$nulls":12},"Page 4"]
[]
[null,"Statement of Activities"]
[null,"FYE June 30, 2022"]
[null,"(continued)"]
[]
[{"$nulls":5},"Church &",null,"School &"]
[{"$nulls":5},"Rectory",null,"Convent",null,"Cemetery",null,"Total",null,null,"Reference"]
["Expenses (continued):",{"$nulls":15},"Note",null,"The revenue reported by the School on Line 444 (School"]
[null,540,null,"Parish School Subsidy",null,0,null,0,null,0,null,{"$f":"SUM(F10:J10)","v":0},null,null,"Line 444",null,"Subsidy from Parish) must agree with the expense reported by the Church on "]
[null,542,null,"Parish High School Subsidy",null,0,null,0,null,0,null,{"$f":"SUM(F11:J11)","v":0},null,null,"-",null,"Line 540 (Parish School Subsidy)."]
[null,543,null,"Scholarships & Grants",null,0,null,0,null,0,null,0,null,null,"-",null,{"$f":"IF(('Activities 1'!H44='Activities 3'!F10),\"OK\",\"Error\")","v":"OK"},null,{"$f":"\"Line 444 = \"&TEXT('Activities 1'!H44,\"$#,##0\")","v":"Line 444 = $0"},null,null,{"$f":"\"Line 540 = \"&TEXT('Activities 3'!F10,\"$#,##0\")","v":"Line 540 = $0"}]
[null,545,null,"Religious Education",null,0,null,0,null,0,null,0,null,null,"-",{"$nulls":3},{"$f":"\"There is a difference of \"&TEXT(ABS('Activities 1'!H44-'Activities 3'!F10),\"$#,##0\")&\".\"","v":"There is a difference of $0."}]
[null,546,null,"Liturgy & Worship",null,0,null,0,null,0,null,0,null,null,"-"]
[null,547,null,"Charities & Social Concerns",null,0,null,0,null,0,null,0,null,null,"-",null,"Note",null,"Except where indicated, Parishes should not net revenues"]
[null,548,null,"Other Ministries",null,0,null,0,null,0,null,0,null,null,"-",null,"and expenses in any account on the Statement of Activities.  The exceptions to this"]
[{"$nulls":16},"rule are Lines 406 (Fundraising), 570 (Food Service Operations), and 571 (Student "]
[{"$nulls":16},"Activities).  "]
[{"$nulls":3},"Parish Life & Ministries (subtotal):",null,{"$f":"SUM(F10:F17)","v":0},null,{"$f":"SUM(H10:H17)","v":0},null,{"$f":"SUM(J10:J17)","v":0},null,{"$f":"SUM(L10:L17)","v":0},null,null,"-"]
[{"$nulls":16},"Note",null,"The sub-account 545.07 (Catholic Spirit Subscription"]
[{"$nulls":16},"Expense) is no longer used.  This expense should be reported with the Diocesan"]
[null,550,null,"Textbooks & Workbooks",null,0,null,0,null,0,null,{"$f":"SUM(F22:J22)","v":0},null,null,"-",null,"Collections on the top of \"Schedule 6 - Special Weekend Collections\" as “Catholic"]
[null,551,null,"Library Expenses",null,0,null,0,null,0,null,0,null,null,"-",null,"Press Month.”"]
[null,552,null,"Consumable Teaching Supplies",null,0,null,0,null,0,null,0,null,null,"-"]
[null,553,null,"Instructional Materials",null,0,null,0,null,0,null,0,null,null,"-"]
[null,554,null,"Other Expense for Instruction",null,0,null,0,null,0,null,0,null,null,"-"]
[null,555,null,"Staff Development",null,0,null,0,null,0,null,0,null,null,"-"]
[]
[]
[{"$nulls":3},"Instruction (subtotal):",null,{"$f":"SUM(F22:F28)","v":0},null,{"$f":"SUM(H22:H28)","v":0},null,{"$f":"SUM(J22:J28)","v":0},null,{"$f":"SUM(L22:L28)","v":0},null,null,"-"]
[]
[]
[null,563,null,"Mortgage & Loan Payments - Interest",null,{"$f":"'Sch. 4'!K26","v":0},null,{"$f":"'Sch. 4'!K48","v":0},null,{"$f":"'Sch. 4'!K68","v":0},null,{"$f":"SUM(F33:J33)","v":0},null,null,"Sch. 4"]
[null,564,null,"Diocesan Assessments",null,0,null,0,null,0,null,0,null,null,"-",null,"Note",null,"Parishes should report the total of all Assessment expenses"]
[null,565,null,"Diocesan Collections",null,{"$f":"'Sch. 6'!H18","v":0},null,0,null,0,null,0,null,null,"Sch. 6",null,"billed for the fiscal year by the Diocese, including the Ordinary Assessment"]
[null,566,null,"National & Missionary Appeals",null,{"$f":"'Sch. 6'!H41","v":0},null,0,null,0,null,0,null,null,"Sch. 6",null,"(Diocesan & High School Assessments), the Elementary School Assessment, and "]
[null,567,null,"Goal Payment - Bishop's Appeal",null,0,null,0,null,0,null,0,null,null,"-",null,"the School Rental Assessment (if applicable). "]
[null,568,null,"Development Expense",null,0,null,0,null,0,null,0,null,null,"-"]
[null,569,null,"Rental of Land & Buildings",null,0,null,0,null,0,null,0,null,null,"-",null,"As with all revenues and expenses on the Statement of Activities, Assessments"]
[null,570,null,"Food Service Operations (Net)",null,0,null,0,null,0,null,0,null,null,"-",null,"must be reported on a full accrual basis.  The entire sum of all Assessment"]
[null,571,null,"Student Activities (Net)",null,0,null,0,null,0,null,0,null,null,"-",null,"expenses billed for each fiscal year should be reported here regardless of when"]
[null,572,null,"Other Fixed Expenses",null,{"$f":"'Sch. 7'!E51","v":0},null,{"$f":"'Sch. 7'!G51","v":0},null,{"$f":"'Sch. 7'!I51","v":0},null,0,null,null,"Sch. 7",null,"they are paid.  "]
[null,573,null,"Depreciation Expense - Buildings",null,0,null,0,null,0,null,0,null,null,"-"]
[null,574,null,"Depreciation Expense - Building Imp.",null,0,null,0,null,0,null,0,null,null,"-",null,"If any payments are outstanding at the end of the fiscal year, the Parish should"]
[null,575,null,"Depreciation Expense - Vehicle",null,0,null,0,null,0,null,0,null,null,"-",null,"establish a liability on Line 201 (Assessments Payable)."]
[null,576,null,"Depreciation Expense - Furn. & Equip.",null,0,null,0,null,0,null,0,null,null,"-"]
[]
[{"$nulls":16},"Note",null,"The term \"Change in Net Assets\" closely resembles the "]
[{"$nulls":3},"Extraordinary Expenses (subtotal):",null,{"$f":"SUM(F33:F47)","v":0},null,{"$f":"SUM(H33:H47)","v":0},null,{"$f":"SUM(J33:J47)","v":0},null,{"$f":"SUM(L33:L47)","v":0},null,null,"-",null,"concept of Profit/(Loss) in a for-profit setting.  A \"profit\" from the Parish's operations"]
[{"$nulls":16},"results in an increase in Net Assets, while a \"loss\" from the Parish's operations"]
[{"$nulls":3},"Total Expenses:",null,{"$f":"'Activities 2'!F26+'Activities 2'!F40+'Activities 2'!F55+'Activities 3'!F19+'Activities 3'!F30+'Activities 3'!F49","v":0},null,{"$f":"'Activities 2'!H26+'Activities 2'!H40+'Activities 2'!H55+'Activities 3'!H19+'Activities 3'!H30+'Activities 3'!H49","v":0},null,{"$f":"'Activities 2'!J26+'Activities 2'!J40+'Activities 2'!J55+'Activities 3'!J19+'Activities 3'!J30+'Activities 3'!J49","v":0},null,{"$f":"SUM(F51:J51)","v":0},null,null,"-",null,"results in a decrease in Net Assets."]
[]
[{"$nulls":3},"Change in Net Assets:",null,{"$f":"'Activities 1'!F56-'Activities 3'!F51","v":0},null,{"$f":"'Activities 1'!H56-'Activities 3'!H51","v":0},null,{"$f":"'Activities 1'!J56-'Activities 3'!J51","v":0},null,{"$f":"SUM(F53:J53)","v":0},null,null,"Disclosures"]

{"sheet":"Disclosures","index":6,"n_rows":66,"n_cols":35,"rows_kept":66,"merged":[[2,1,2,27],[3,32,3,33],[15,32,15,33],[18,2,18,27],[19,2,19,27],[22,32,23,33],[22,34,23,39],[23,1,23,27],[26,32,26,33],[40,1,40,27],[43,32,43,33],[60,32,60,33]]}
[{"$nulls":28},"Page 5"]
[]
[null,"Net Asset Roll-Forward"]
[{"$nulls":32},"Instructions",null,"The Net Asset Roll-Forward provides a “proof” that all"]
[{"$nulls":21},"Church &",null,"School &",{"$nulls":8},"transactions have been reported utilizing double-entry bookkeeping."]
[{"$nulls":21},"Rectory",null,"Convent",null,"Cemetery",null,"Total",null,null,"Reference"]
[{"$nulls":32},"Net Assets are calculated on the Statement of Financial Position as the difference "]
[null,null,"Net Assets - Beginning of Year",{"$nulls":18},{"$f":"'Sch. 8'!F46","v":0},null,{"$f":"'Sch. 8'!H46","v":0},null,{"$f":"'Sch. 8'!J46","v":0},null,{"$f":"SUM(V8:Z8)","v":0},null,null,"Sch. 8",null,"between Total Assets and Total Liabilities.  The Roll-Forward takes the previous"]
[null,null,"Plus:  Change in Net Assets",{"$nulls":18},{"$f":"'Activities 3'!F53","v":0},null,{"$f":"'Activities 3'!H53","v":0},null,{"$f":"'Activities 3'!J53","v":0},null,{"$f":"SUM(V9:Z9)","v":0},null,null,"Δ Net Assets",null,"year's ending Net Assets from \"Schedule 8 - Prior Year Worksheet\" and adds or"]
[{"$nulls":32},"subtracts the current year's Change in Net Assets from the Statement of Activities "]
[null,null,"Net Assets - End of Year:",{"$nulls":29},"to arrive at the current year's ending Net Assets.  "]
[{"$nulls":3},"Calculated Above",{"$nulls":17},{"$f":"SUM(V8:V11)","v":0},null,{"$f":"SUM(X8:X11)","v":0},null,{"$f":"SUM(Z8:Z11)","v":0},null,{"$f":"SUM(AB8:AB11)","v":0},null,null,"-"]
[{"$nulls":3},"From Statement of Financial Position",{"$nulls":17},{"$f":"Position!F50","v":0},null,{"$f":"Position!H50","v":0},null,{"$f":"Position!J50","v":0},null,{"$f":"SUM(V13:Z13)","v":0},null,null,"Line 300",null,"When all of the transactions which took place during the fiscal year are reported"]
[{"$nulls":32},"correctly, the two methods of calculating Net Assets will arrive at the same balance."]
[]
[null,null,"Difference (calculated less reported)*",{"$nulls":18},{"$f":"V12-V13","v":0},null,{"$f":"X12-X13","v":0},null,{"$f":"Z12-Z13","v":0},null,{"$f":"AB12-AB13","v":0},null,null,"-",null,"Note",null,"If you have completed your statement and the Roll-Forward"]
[{"$nulls":32},"contains a difference, double-check the following:  1)  No entries have been made"]
[{"$nulls":32},"directly to Line 300 (Net Assets), 2)  Any prior year accruals have been reversed"]
[null,null,"* There should not be a difference on this line. A difference can indicate (a) Net Assets-Beginning of Year  ",{"$nulls":29},"properly, and 3)  Any necessary accruals have been made in the current year."]
[null,null,"was not correctly brought forward or (b) Change in Net Assets is not correct. Please check."]
[{"$nulls":32},"If you are still unable to balance this Net Asset Roll-Forward, please contact Jeffrey"]
[{"$nulls":32},"Greczek for assistance at jgreczek@diometuchen.org or (732) 562-2429."]
[{"$nulls":32},{"$f":"IF(OR(1<V16,V16<-1,1<X16,X16<-1,1<Z16,Z16<-1),\"Error\",\"OK\")","v":"OK"},null,{"$f":"IF(OR(1<V16,V16<-1,1<X16,X16<-1,1<Z16,Z16<-1),\"Your Net Asset Roll-Forward is out of balance.\",\"Your Net Asset Roll-Forward is in balance.\")","v":"Your Net Asset Roll-Forward is in balance."}]
[null,"Cash Flows From Operations"]
[]
[{"$nulls":21},"Church &",null,"School &"]
[{"$nulls":21},"Rectory",null,"Convent",null,"Cemetery",null,"Total",null,null,"Reference"]
[]
[null,null,"Change in Net Assets",{"$nulls":18},{"$f":"'Activities 3'!F53","v":0},null,{"$f":"'Activities 3'!H53","v":0},null,{"$f":"'Activities 3'!J53","v":0},null,{"$f":"SUM(V29:Z29)","v":0},null,null,"Δ Net Assets"]
[{"$nulls":3},"Plus:  Depreciation Expense",{"$nulls":17},{"$f":"SUM('Activities 3'!F43:F46)","v":0},null,{"$f":"SUM('Activities 3'!H43:H46)","v":0},null,{"$f":"SUM('Activities 3'!J43:J46)","v":0},null,0,null,null,"Lines 573-576"]
[{"$nulls":3},"Less:  Capitalized Assets",{"$nulls":17},{"$f":"-('Sch. 3'!E10+'Sch. 3'!E22+SUM('Sch. 3'!E36:E39)+SUM('Sch. 3'!E53:E54)+SUM('Sch. 3'!E68:E71))","v":0},null,{"$f":"-('Sch. 3'!G10+'Sch. 3'!G22+SUM('Sch. 3'!G36:G39)+SUM('Sch. 3'!G53:G54)+SUM('Sch. 3'!G68:G71))","v":0},null,{"$f":"-('Sch. 3'!I10+'Sch. 3'!I22+SUM('Sch. 3'!I36:I39)+SUM('Sch. 3'!I53:I54)+SUM('Sch. 3'!I68:I71))","v":0},null,0,null,null,"Sch. 3"]
[{"$nulls":3},"Less:  Loan Principal Payments",{"$nulls":17},{"$f":"-('Sch. 4'!I10+SUM('Sch. 4'!I13:I17))","v":0},null,{"$f":"-('Sch. 4'!I32+SUM('Sch. 4'!I35:I39))","v":0},null,{"$f":"-('Sch. 4'!I54+SUM('Sch. 4'!I57:I59))","v":0},null,0,null,null,"Sch. 4"]
[{"$nulls":3},"Plus:  Unrealized Losses",{"$nulls":17},{"$f":"IF('Activities 1'!F33<0,-'Activities 1'!F33,0)","v":0},null,{"$f":"IF('Activities 1'!H33<0,-'Activities 1'!H33,0)","v":0},null,{"$f":"IF('Activities 1'!J33<0,-'Activities 1'!J33,0)","v":0},null,0,null,null,"Line 426"]
[{"$nulls":3},"Less:  Unrealized Gains",{"$nulls":17},{"$f":"IF('Activities 1'!F33>0,-'Activities 1'!F33,0)","v":0},null,{"$f":"IF('Activities 1'!H33>0,-'Activities 1'!H33,0)","v":0},null,{"$f":"IF('Activities 1'!J33>0,-'Activities 1'!J33,0)","v":0},null,0,null,null,"Line 426"]
[]
[]
[null,null,"Cash Flow From Operations",{"$nulls":18},{"$f":"SUM(V29:V36)","v":0},null,{"$f":"SUM(X29:X36)","v":0},null,{"$f":"SUM(Z29:Z36)","v":0},null,{"$f":"SUM(AB29:AB36)","v":0}]
[]
[]
[]
[null,"Supplemental Disclosures"]
[]
[{"$nulls":21},"Church &",null,"School &"]
[{"$nulls":21},"Rectory",null,"Convent",null,"Cemetery",null,"Total",null,null,"Reference",null,"Instructions"," ","The Supplemental Disclosures are a collection of "]
[null,null,"Principal Payments",{"$nulls":29},"disclosures which present information previously reported on the Statement of"]
[{"$nulls":3},"Diocesan Loans",{"$nulls":17},{"$f":"'Sch. 4'!I23","v":0},null,{"$f":"'Sch. 4'!I45","v":0},null,{"$f":"'Sch. 4'!I65","v":0},null,{"$f":"SUM(V46:Z46)","v":0},null,null,"Sch. 4",null,"Revenues & Expenditures in previous year’s reports, but which are no longer"]
[{"$nulls":3},"External Mortgages & Loans",{"$nulls":17},{"$f":"'Sch. 4'!I22","v":0},null,{"$f":"'Sch. 4'!I44","v":0},null,{"$f":"'Sch. 4'!I64","v":0},null,{"$f":"SUM(V47:Z47)","v":0},null,null,"Sch. 4",null,"presented on the Statement of Activities."]
[]
[null,null,"Purchase/(Disposal) of Fixed Assets",{"$nulls":29},"All of the data on this page populates from other sections of the report, with the"]
[{"$nulls":4},"Land",{"$nulls":16},{"$f":"(Position!F20-'Sch. 8'!F21)","v":0},null,{"$f":"(Position!H20-'Sch. 8'!H21)","v":0},null,{"$f":"(Position!J20-'Sch. 8'!J21)","v":0},null,{"$f":"SUM(V50:Z50)","v":0},null,null,"Line 110",null,"exception of the information regarding deposits to and withdrawals from the"]
[{"$nulls":4},"Buildings",{"$nulls":16},{"$f":"(Position!F21-'Sch. 8'!F22)","v":0},null,{"$f":"(Position!H21-'Sch. 8'!H22)","v":0},null,{"$f":"(Position!J21-'Sch. 8'!J22)","v":0},null,{"$f":"SUM(V51:Z51)","v":0},null,null,"Line 111",null,"Parish's investment accounts, which must be entered in the green cells manually."]
[{"$nulls":4},"Building Improvements",{"$nulls":16},{"$f":"(Position!F22-'Sch. 8'!F23)","v":0},null,{"$f":"(Position!H22-'Sch. 8'!H23)","v":0},null,{"$f":"(Position!J22-'Sch. 8'!J23)","v":0},null,0,null,null,"Line 112"]
[{"$nulls":4},"Vehicles",{"$nulls":16},{"$f":"(Position!F23-'Sch. 8'!F24)","v":0},null,{"$f":"(Position!H23-'Sch. 8'!H24)","v":0},null,{"$f":"(Position!J23-'Sch. 8'!J24)","v":0},null,0,null,null,"Line 113"]
[{"$nulls":4},"Furniture & Equipment",{"$nulls":16},{"$f":"(Position!F24-'Sch. 8'!F25)","v":0},null,{"$f":"(Position!H24-'Sch. 8'!H25)","v":0},null,{"$f":"(Position!J24-'Sch. 8'!J25)","v":0},null,0,null,null,"Line 114"]
[]
[null,null,"Diocesan Investment Mgmt. Program"]
[{"$nulls":4},"Additions (exclude reinvested interest)",{"$nulls":16},0,null,0,null,0,null,{"$f":"SUM(V57:Z57)","v":0},null,null,"-"]
[{"$nulls":4},"Withdrawals",{"$nulls":16},0,null,0,null,0,null,0,null,null,"-"]
[]
[null,null,"External Investments"]
[{"$nulls":4},"Additions (exclude reinvested int. & div.)",{"$nulls":16},0,null,0,null,0,null,{"$f":"SUM(V61:Z61)","v":0},null,null,"-",null,"Note",null,"The Average Weekend Collection is calculated as Line 400"]
[{"$nulls":4},"Withdrawals",{"$nulls":16},0,null,0,null,0,null,0,null,null,"-",null,"(Weekend Collections) divided by 51, which is the number of Sundays in the fiscal "]
[{"$nulls":32},"year not including Easter.  The Average Donation per Registered Family is calculated"]
[null,null,"Collection Statistics",{"$nulls":29},"as Line 400 divided by the number of Registered Catholic Families reported on the"]
[{"$nulls":4},"Average Weekend Collection (51 weeks)",{"$nulls":16},{"$f":"'Activities 1'!F10/51","v":0},{"$nulls":8},"Line 400",null,"cover of this statement."]
[{"$nulls":4},"Average Donation per Registered Family",{"$nulls":16},{"$f":"IF(Cover!G15=0,0,'Activities 1'!F10/Cover!G15)","v":0},{"$nulls":8},"Cover"]

{"sheet":"Sch. 1","index":7,"n_rows":58,"n_cols":17,"rows_kept":58,"merged":[[2,0,2,10],[5,1,5,9],[6,1,7,1],[6,5,7,5],[6,14,6,15],[13,14,13,15],[18,14,18,15],[27,1,27,9],[28,1,29,1],[28,5,29,5],[47,1,47,9],[48,1,49,1],[48,5,49,5],[60,0,61,10],[62,0,63,10]]}
[{"$nulls":10},"Schedule 1"]
[]
["Cash "]
[]
[]
[null,"Church"]
[null,"#",null,"Financial",null,"Description",null,"Interest",null,"Balance at",{"$nulls":4},"Instructions",null,"\"Schedule 1 - Cash\" is intended to report a detailed"]
[{"$nulls":3},"Institution",{"$nulls":3},"Rate",null,"2022-06-30",null,null,"Reference",null,"breakdown of the Parish's bank accounts."]
[]
[null,1,null,"-",null,"Operating",null,{"v":0,"d":"0.00%"},null,0,null,null,"-",null,"The Schedule is split into Church, School, and Cemetery sections.  When it is"]
[null,2,null,"-",null,"Payroll",null,{"v":0,"d":"0.00%"},null,0,null,null,"-",null,"completed, totals will automatically populate to Line 100 (Cash) on the"]
[null,3,null,"-",null,"Stipend",null,{"v":0,"d":"0.00%"},null,0,null,null,"-",null,"Statement of Position.   "]
[null,4,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[null,5,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-",null,"Note",null,"Each cash account should be reported as a separate"]
[null,6,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-",null,"line item.  If more space is needed, attach a list of additional bank accounts, "]
[null,7,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-",null,"enter the total of these accounts on the last available line, and indicate \"see"]
[null,8,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-",null,"attached list\" in the description field."]
[null,9,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[null,10,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-",null,"Note",null,"Please forward a copy of the June 30, 2018 statement"]
[null,11,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-",null,"for each bank account listed on Schedule 1.  Only send the account summary"]
[null,12,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-",null,"and balance.  You do not need to send transaction histories or check images."]
[null,13,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[null,14,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[]
[]
[{"$nulls":7},"Total:",null,{"$f":"SUM(J10:J25)","v":0},null,null,"Line 100"]
[]
[null,"School"]
[null,"#",null,"Financial",null,"Description",null,"Interest",null,"Balance at"]
[{"$nulls":3},"Institution",{"$nulls":3},"Rate",null,"2022-06-30",null,null,"Reference"]
[]
[null,1,null,"-",null,"Operating",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[null,2,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[null,3,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[null,4,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[null,5,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[null,6,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[null,7,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[null,8,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[null,9,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[null,10,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[null,11,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[null,12,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[]
[]
[{"$nulls":7},"Total:",null,{"$f":"SUM(J32:J45)","v":0},null,null,"Line 100"]
[]
[null,"Cemetery"]
[null,"#",null,"Financial",null,"Description",null,"Interest",null,"Balance at"]
[{"$nulls":3},"Institution",{"$nulls":3},"Rate",null,"2022-06-30",null,null,"Reference"]
[]
[null,1,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[null,2,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[null,3,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[null,4,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,null,"-"]
[]
[]
[{"$nulls":7},"Total:",null,{"$f":"SUM(J52:J57)","v":0},null,null,"Line 100"]

{"sheet":"Sch. 2","index":8,"n_rows":69,"n_cols":27,"rows_kept":69,"merged":[[2,0,2,14],[4,16,4,18],[4,20,4,22],[5,0,5,14],[5,16,5,22],[6,0,7,0],[6,4,7,4],[6,10,6,12],[6,24,6,25],[20,24,20,25],[25,24,25,25],[29,0,29,14],[30,0,31,0],[30,4,31,4],[30,10,30,12],[30,24,30,25],[36,24,36,25],[40,24,40,25],[53,0,53,14],[54,0,55,0],[54,4,55,4],[54,10,54,12],[71,0,72,14],[73,0,74,14]]}
[{"$nulls":14},"Schedule 2"]
[]
["Investments "]
[]
[{"$nulls":16},"Instructions",{"$nulls":3},"Notes"]
["Church",{"$nulls":15},"®   ®   ®   ®   ®   ®   ®   ®   ®   ®   ®   ®   ®"]
["#",null,"Financial",null,"Description",null,"Interest",null,"Dividends &",null,"Gains / (Losses)",{"$nulls":3},"FMV at",{"$nulls":9},"Instructions",null,"\"Schedule 2 - Investments\" is intended to report a"]
[null,null,"Institution",{"$nulls":3},"Rate",null,"Interest Earned",null,"Unrealized",null,"Realized",null,"2022-06-30",null,"Reference",null,"Reference",null,"Reference",null,"Reference",null,"detailed breakdown of the Parish's Diocesan and external investments."]
[]
["-",null,"Diocese of Metuchen",null,"Total Investment Mgmt. Program",null,"1.5 - 3%",null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-",null,"The Schedule is split into Church, School, and Cemetery sections.  When it is"]
[1,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-",null,"completed, totals will automatically populate to the correct places in the"]
[2,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-",null,"Statement of Position and the Statement of Activities."]
[3,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-"]
[4,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-",null,"Report the combined total for all  Diocesan Investment Management"]
[5,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-",null,"Program accounts as one combined line item, using the remaining lines for"]
[6,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-",null,"external investments."]
[7,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-"]
[8,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-",null,"Information regarding any additions to or withdrawals from investment"]
[9,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-",null,"accounts must be reported manually in the “Supplemental Disclosures” section."]
[]
[{"$nulls":24},"Note",null,"Examples of investments to be reported on Schedule 2 "]
[{"$nulls":6},"Total:",null,{"$f":"SUM(I10:I21)","v":0},null,{"$f":"SUM(K10:K21)","v":0},null,{"$f":"SUM(M10:M21)","v":0},null,{"$f":"SUM(O10:O21)","v":0},null,"-",null,"-",null,"-",null,"-",null,"include bonds, certificates of deposit, mutual funds, and stocks.  Schedule 2"]
[{"$nulls":24},"should not include savings accounts or Money Market Accounts, which should "]
[{"$nulls":6},"External Investments:",null,{"$f":"SUM(I11:I19)","v":0},null,{"$f":"SUM(K11:K19)","v":0},null,{"$f":"SUM(M11:M19)","v":0},null,{"$f":"SUM(O11:O19)","v":0},null,"-",null,"Line 426",null,"Line 427",null,"Line 104",null,"be reported on \"Schedule 1 – Cash\" and included in Line 100."]
[{"$nulls":6},"Diocesan Investment Management Program:",null,{"$f":"I10","v":0},null,{"$f":"K10","v":0},null,{"$f":"M10","v":0},null,{"$f":"O10","v":0},null,"Line 420",null,"-",null,"-",null,"Line 102"]
[{"$nulls":24},"Note",null,"Please forward a copy of the entire June 30, 2018"]
[{"$nulls":24},"statement for each external investment listed on Schedule 2.  You do not need"]
[{"$nulls":6},"Total:",null,{"$f":"SUM(I24:I27)","v":0},null,{"$f":"SUM(K24:K27)","v":0},null,{"$f":"SUM(M24:M27)","v":0},null,{"$f":"SUM(O24:O27)","v":0},null,"-",null,"-",null,"-",null,"-",null,"to send statements for investments in the Diocesan Investment Management"]
[{"$nulls":24},"Program."]
["School"]
["#",null,"Financial",null,"Description",null,"Interest",null,"Dividends &",null,"Gains / (Losses)",{"$nulls":3},"FMV at",{"$nulls":9},"Note",null,"Dividends & Interest Earned:  enter the total of all"]
[null,null,"Institution",{"$nulls":3},"Rate",null,"Interest Earned",null,"Unrealized",null,"Realized",null,"2022-06-30",null,"Reference",null,"Reference",null,"Reference",null,"Reference",null,"interest and dividend revenue earned during the fiscal year.  For interest or"]
[{"$nulls":24},"dividends earned during the fiscal year but not yet received, include them here"]
["-",null,"Diocese of Metuchen",null,"Total Investment Mgmt. Program",null,"1.5 - 3%",null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-",null,"and establish a receivable on Line 107 (Accounts Receivable) for the portion"]
[1,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-",null,"due to the Parish."]
[2,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-"]
[3,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-",null,"Note",null,"Unrealized Gains/(Losses):  Enter the net total of any"]
[4,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-",null,"increases or decreases in the fair market value of investments as compared to"]
[5,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-",null,"last year’s Parish Financial Statement & Report."]
[6,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-"]
[7,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-",null,"Note",null,"Realized Gains/(Losses):  Realized Gains/(Losses) are"]
[8,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-",null,"only reported upon the sale of investments.  Enter the difference between the "]
[9,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-",null,"last reported fair market value and the amount of the sale."]
[]
[]
[{"$nulls":6},"Total:",null,{"$f":"SUM(I34:I45)","v":0},null,{"$f":"SUM(K34:K45)","v":0},null,{"$f":"SUM(M34:M45)","v":0},null,{"$f":"SUM(O34:O45)","v":0},null,"-",null,"-",null,"-",null,"-"]
[]
[{"$nulls":6},"External Investments:",null,{"$f":"SUM(I35:I43)","v":0},null,{"$f":"SUM(K35:K43)","v":0},null,{"$f":"SUM(M35:M43)","v":0},null,{"$f":"SUM(O35:O43)","v":0},null,"-",null,"Line 426",null,"Line 427",null,"Line 104"]
[{"$nulls":6},"Diocesan Investment Management Program:",null,{"$f":"SUM(I34)","v":0},null,{"$f":"SUM(K34)","v":0},null,{"$f":"SUM(M34)","v":0},null,{"$f":"SUM(O34)","v":0},null,"Line 420",null,"-",null,"-",null,"Line 102"]
[]
[]
[{"$nulls":6},"Total:",null,{"$f":"SUM(I48:I51)","v":0},null,{"$f":"SUM(K48:K51)","v":0},null,{"$f":"SUM(M48:M51)","v":0},null,{"$f":"SUM(O48:O51)","v":0},null,"-",null,"-",null,"-",null,"-"]
[]
["Cemetery"]
["#",null,"Financial",null,"Description",null,"Interest",null,"Dividends &",null,"Gains / (Losses)",{"$nulls":3},"FMV at"]
[null,null,"Institution",{"$nulls":3},"Rate",null,"Interest Earned",null,"Unrealized",null,"Realized",null,"2022-06-30",null,"Reference",null,"Reference",null,"Reference",null,"Reference"]
[]
["-",null,"Diocese of Metuchen",null,"Total Investment Mgmt. Program",null,"1.5 - 3%",null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-"]
[1,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-"]
[2,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"-"]
[]
[]
[{"$nulls":6},"Total:",null,{"$f":"SUM(I58:I62)","v":0},null,{"$f":"SUM(K58:K62)","v":0},null,{"$f":"SUM(M58:M62)","v":0},null,{"$f":"SUM(O58:O62)","v":0},null,"-",null,"-",null,"-",null,"-"]
[]
[{"$nulls":6},"External Investments:",null,{"$f":"SUM(I59:I60)","v":0},null,{"$f":"SUM(K59:K60)","v":0},null,{"$f":"SUM(M59:M60)","v":0},null,{"$f":"SUM(O59:O60)","v":0},null,"-",null,"Line 426",null,"Line 427",null,"Line 104"]
[{"$nulls":6},"Diocesan Investment Management Program:",null,{"$f":"SUM(I58)","v":0},null,{"$f":"SUM(K58)","v":0},null,{"$f":"SUM(M58)","v":0},null,{"$f":"SUM(O58)","v":0},null,"Line 420",null,"-",null,"-",null,"Line 102"]
[]
[]
[{"$nulls":6},"Total:",null,{"$f":"SUM(I65:I68)","v":0},null,{"$f":"SUM(K65:K68)","v":0},null,{"$f":"SUM(M65:M68)","v":0},null,{"$f":"SUM(O65:O68)","v":0},null,"-",null,"-",null,"-",null,"-"]

{"sheet":"Sch. 3","index":9,"n_rows":77,"n_cols":17,"rows_kept":77,"merged":[[2,1,2,10],[5,1,5,10],[6,1,7,2],[6,8,7,8],[6,10,7,10],[6,14,6,15],[16,1,16,10],[17,1,18,2],[17,8,18,8],[17,10,18,10],[20,14,20,15],[30,1,30,10],[31,1,32,2],[31,8,32,8],[31,10,32,10],[47,1,47,10],[48,1,49,2],[48,8,49,8],[48,10,49,10],[62,1,62,10],[63,1,64,2],[63,8,64,8],[63,10,64,10]]}
[{"$nulls":10},"Schedule 3"]
[]
[null,"Fixed Assets"]
[]
[]
[null,"Land"]
[null,"Description",null,null,"Church &",null,"School &",null,"Cemetery",null,"Total",{"$nulls":3},"Instructions",null,"\"Schedule 3 - Fixed Assets\" is intended to provide a "]
[{"$nulls":4},"Rectory",null,"Convent",{"$nulls":5},"Reference",null,"detailed breakdown of fixed assets purchased and disposed of during the "]
[{"$nulls":14},"year. "]
[null,"-","Purchases",null,0,null,0,null,0,null,{"$f":"SUM(E10:I10)","v":0},null,"-"]
[null,"-","Disposals",null,0,null,0,null,0,null,{"$f":"SUM(E11:I11)","v":0},null,"-",null,"The Schedule is split into sections by asset type.  When it is completed, totals"]
[{"$nulls":14},"will automatically populate to the correct places in the Statement of Position."]
[{"$nulls":12},"Sch. 7"]
[null,null,"Total Change:",null,{"$f":"E10-E11","v":0},null,{"$f":"G10-G11","v":0},null,{"$f":"I10-I11","v":0},null,{"$f":"K10-K11","v":0},null,"Line 110",null,"This schedule should also be used to remove Accumulated Depreciation (A/D)"]
[{"$nulls":14},"from the Statement of Position when the corresponding fixed assets are"]
[{"$nulls":14},"disposed of.  Enter only positive numbers."]
[null,"Buildings"]
[null,"Description",null,null,"Church &",null,"School &",null,"Cemetery",null,"Total",{"$nulls":3},"Additions to A/D, which are entered as expenses on Lines 573-576 in the"]
[{"$nulls":4},"Rectory",null,"Convent",{"$nulls":5},"Reference",null,"Statement of Position, should not be entered here."]
[]
[{"$nulls":14},"Note",null,"Items which the Parish intends to expense immediately"]
[null,"-","Purchases",null,0,null,0,null,0,null,{"$f":"SUM(E22:I22)","v":0},null,"-",null,"should not be included on \"Schedule 3 - Fixed Assets\", but rather should be"]
[null,"-","Disposals",null,0,null,0,null,0,null,{"$f":"SUM(E23:I23)","v":0},null,"-",null,"reported on the Statement of Activities using the following lines:"]
[{"$nulls":15},"-","512 (Furniture & Equipment < $500)"]
[{"$nulls":12},"Sch. 7",null,null,"-","521 (Repairs & Renovations < $5,000)"]
[null,null,"Total Change:",null,{"$f":"E22-E23","v":0},null,{"$f":"G22-G23","v":0},null,{"$f":"I22-I23","v":0},null,{"$f":"K22-K23","v":0},null,"Line 111",null,null,"-","523 (Maintenance Equipment < $500)"]
[{"$nulls":12},"Sch. 7"]
[null,null,"Disposal of A/D: ",null,0,null,0,null,0,null,{"$f":"SUM(E28:I28)","v":0},null,"Line 115"]
[]
[]
[null,"Building Improvements"]
[null,"Description",null,null,"Church &",null,"School &",null,"Cemetery",null,"Total"]
[{"$nulls":4},"Rectory",null,"Convent",{"$nulls":5},"Reference"]
[]
[null,"-","Purchases:"]
[null,1,"-",null,0,null,0,null,0,null,{"$f":"SUM(E36:I36)","v":0},null,"-"]
[null,2,"-",null,0,null,0,null,0,null,{"$f":"SUM(E37:I37)","v":0},null,"-"]
[null,3,"-",null,0,null,0,null,0,null,{"$f":"SUM(E38:I38)","v":0},null,"-"]
[null,4,"-",null,0,null,0,null,0,null,{"$f":"SUM(E39:I39)","v":0},null,"-"]
[null,"-","Disposals",null,0,null,0,null,0,null,{"$f":"SUM(E40:I40)","v":0},null,"-"]
[]
[{"$nulls":12},"Sch. 7"]
[null,null,"Total Change:",null,{"$f":"SUM(E36:E39)-E40","v":0},null,{"$f":"SUM(G36:G39)-G40","v":0},null,{"$f":"SUM(I36:I39)-I40","v":0},null,{"$f":"SUM(K36:K39)-K40","v":0},null,"Line 112"]
[{"$nulls":12},"Sch. 7"]
[null,null,"Disposal of A/D: ",null,0,null,0,null,0,null,{"$f":"SUM(E45:I45)","v":0},null,"Line 116"]
[]
[]
[null,"Vehicles"]
[null,"Description",null,null,"Church &",null,"School &",null,"Cemetery",null,"Total"]
[{"$nulls":4},"Rectory",null,"Convent",{"$nulls":5},"Reference"]
[]
[null,"-","Purchases:"]
[null,1,"-",null,0,null,0,null,0,null,{"$f":"SUM(E53:I53)","v":0},null,"-"]
[null,2,"-",null,0,null,0,null,0,null,{"$f":"SUM(E54:I54)","v":0},null,"-"]
[null,"-","Disposals",null,0,null,0,null,0,null,{"$f":"SUM(E55:I55)","v":0},null,"-"]
[]
[{"$nulls":12},"Sch. 7"]
[null,null,"Total Change:",null,{"$f":"SUM(E53:E54)-E55","v":0},null,{"$f":"SUM(G53:G54)-G55","v":0},null,{"$f":"SUM(I53:I54)-I55","v":0},null,{"$f":"SUM(K53:K54)-K55","v":0},null,"Line 113"]
[{"$nulls":12},"Sch. 7"]
[null,null,"Disposal of A/D: ",null,0,null,0,null,0,null,{"$f":"SUM(E60:I60)","v":0},null,"Line 117"]
[]
[]
[null,"Furniture & Equipment"]
[null,"Description",null,null,"Church &",null,"School &",null,"Cemetery",null,"Total"]
[{"$nulls":4},"Rectory",null,"Convent",{"$nulls":5},"Reference"]
[]
[null,"-","Purchases:"]
[null,1,"-",null,0,null,0,null,0,null,{"$f":"SUM(E68:I68)","v":0},null,"-"]
[null,2,"-",null,0,null,0,null,0,null,{"$f":"SUM(E69:I69)","v":0},null,"-"]
[null,3,"-",null,0,null,0,null,0,null,{"$f":"SUM(E70:I70)","v":0},null,"-"]
[null,4,"-",null,0,null,0,null,0,null,{"$f":"SUM(E71:I71)","v":0},null,"-"]
[null,"-","Disposals:",null,0,null,0,null,0,null,{"$f":"SUM(E72:I72)","v":0},null,"-"]
[]
[{"$nulls":12},"Sch. 7"]
[null,null,"Total Change:",null,{"$f":"SUM(E68:E71)-E72","v":0},null,{"$f":"SUM(G68:G71)-G72","v":0},null,{"$f":"SUM(I68:I71)-I72","v":0},null,{"$f":"SUM(K68:K71)-K72","v":0},null,"Line 114"]
[{"$nulls":12},"Sch. 7"]
[null,null,"Disposal of A/D: ",null,0,null,0,null,0,null,{"$f":"SUM(E77:I77)","v":0},null,"Line 118"]

{"sheet":"Sch. 4","index":10,"n_rows":68,"n_cols":23,"rows_kept":68,"merged":[[2,2,2,12],[5,0,5,12],[6,0,7,0],[6,4,7,4],[6,8,6,10],[6,20,6,21],[24,20,24,21],[27,0,27,12],[28,0,29,0],[28,4,29,4],[28,8,28,10],[49,0,49,12],[50,0,51,0],[50,4,51,4],[50,8,50,10],[70,0,70,12],[71,0,71,12]]}
[{"$nulls":12},"Schedule 4"]
[]
[null,null,"Mortgages & Loans Payable "]
[]
[]
["Church"]
["#",null,"Financial",null,"Description",null,"Interest",null,"Payments This Fiscal Year",{"$nulls":3},"Balance at",{"$nulls":7},"Instructions",null,"\"Schedule 4 - Mortgages & Loans Payable\" is intended"]
[null,null,"Institution",{"$nulls":3},"Rate",null,"Principal",null,"Interest",null,"2022-06-30",null,"Reference",null,"Reference",null,"Reference",null,"to provide a detailed breakdown of funds owed to third parties by the Parish, "]
[{"$nulls":20},"including details of payments made during the fiscal year as well as any unpaid"]
[1,null,"Diocese of Metuchen",null,"Diocesan Loans (formerly PAF)",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"balance at year end.  Report each mortgage or loan as a separate line item.  "]
[2,null,"Parish School",null,"Inter-Parish Loan",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-"]
[3,null,"Parish Cemetery",null,"Inter-Parish Loan",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"The Schedule is split into Church, School, and Cemetery sections.  When it is"]
[4,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"completed, totals will automatically populate to the correct places in the"]
[5,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"Statement of Position and the Statement of Activities."]
[6,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-"]
[7,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"Information regarding any loans taken from the Diocesan Investment"]
[8,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-",null,"Management Program (IMP) should be reported in the appropriate section on"]
[{"$nulls":20},"line 1."]
[]
[{"$nulls":6},"Total:",null,{"$f":"SUM(I10:I19)","v":0},null,{"$f":"SUM(K10:K19)","v":0},null,{"$f":"SUM(M10:M19)","v":0},null,"-",null,"-",null,"-",null,"Loans due to other reporting units in the Parish (Church, Cemetery, or School)"]
[{"$nulls":20},"should be reported in the appropriate section on lines 2 and 3."]
[{"$nulls":6},"Mortgages & Loans Payable:",null,{"$f":"SUM(I11:I17)","v":0},null,{"$f":"SUM(K11:K17)","v":0},null,{"$f":"SUM(M11:M17)","v":0},null,"Disclosures",null,"Line 563",null,"Line 202"]
[{"$nulls":6},"Diocesan Loans Payable:",null,{"$f":"I10","v":0},null,{"$f":"K10","v":0},null,{"$f":"M10","v":0},null,"Disclosures",null,"Line 563",null,"Line 203",null,"Any outstanding \"EDA Loans\" should also be reported on this schedule."]
[]
[{"$nulls":20},"Note",null,"Please forward a copy of the June 30, 2018 statement "]
[{"$nulls":6},"Total:",null,{"$f":"SUM(I22:I23)","v":0},null,{"$f":"SUM(K22:K23)","v":0},null,{"$f":"SUM(M22:M23)","v":0},null,"-",null,"-",null,"-",null,"for each mortgage or loan reported.  You do not need to forward statements"]
[{"$nulls":20},"for loans from the Diocese."]
["School"]
["#",null,"Financial",null,"Description",null,"Interest",null,"Payments This Fiscal Year",{"$nulls":3},"Balance at"]
[null,null,"Institution",{"$nulls":3},"Rate",null,"Principal",null,"Interest",null,"2022-06-30",null,"Reference",null,"Reference",null,"Reference"]
[]
[1,null,"Diocese of Metuchen",null,"Diocesan Loans (formerly PAF)",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-"]
[2,null,"Parish Church",null,"Inter-Parish Loan",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-"]
[3,null,"Parish Cemetery",null,"Inter-Parish Loan",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-"]
[4,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-"]
[5,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-"]
[6,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-"]
[7,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-"]
[8,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-"]
[]
[]
[{"$nulls":6},"Total:",null,{"$f":"SUM(I32:I41)","v":0},null,{"$f":"SUM(K32:K41)","v":0},null,{"$f":"SUM(M32:M41)","v":0},null,"-",null,"-",null,"-"]
[]
[{"$nulls":6},"Mortgages & Loans Payable:",null,{"$f":"SUM(I33:I39)","v":0},null,{"$f":"SUM(K33:K39)","v":0},null,{"$f":"SUM(M33:M39)","v":0},null,"Disclosures",null,"Line 563",null,"Line 202"]
[{"$nulls":6},"Diocesan Loans Payable:",null,{"$f":"I32","v":0},null,{"$f":"K32","v":0},null,{"$f":"M32","v":0},null,"Disclosures",null,"Line 563",null,"Line 203"]
[]
[]
[{"$nulls":6},"Total:",null,{"$f":"SUM(I44:I45)","v":0},null,{"$f":"SUM(K44:K45)","v":0},null,{"$f":"SUM(M44:M45)","v":0},null,"-",null,"-",null,"-"]
[]
["Cemetery"]
["#",null,"Financial",null,"Description",null,"Interest",null,"Payments This Fiscal Year",{"$nulls":3},"Balance at"]
[null,null,"Institution",{"$nulls":3},"Rate",null,"Principal",null,"Interest",null,"2022-06-30",null,"Reference",null,"Reference",null,"Reference"]
[]
[1,null,"Diocese of Metuchen",null,"Diocesan Loans (formerly PAF)",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-"]
[2,null,"Parish Church",null,"Inter-Parish Loan",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-"]
[3,null,"Parish School",null,"Inter-Parish Loan",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-"]
[4,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-"]
[5,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-"]
[6,null,"-",null,"-",null,{"v":0,"d":"0.00%"},null,0,null,0,null,0,null,"-",null,"-",null,"-"]
[]
[]
[{"$nulls":6},"Total:",null,{"$f":"SUM(I54:I61)","v":0},null,{"$f":"SUM(K54:K61)","v":0},null,{"$f":"SUM(M54:M61)","v":0},null,"-",null,"-",null,"-"]
[]
[{"$nulls":6},"Mortgages & Loans Payable:",null,{"$f":"SUM(I55:I59)","v":0},null,{"$f":"SUM(K55:K59)","v":0},null,{"$f":"SUM(M55:M59)","v":0},null,"Disclosures",null,"Line 563",null,"Line 202"]
[{"$nulls":6},"Diocesan Loans Payable:",null,{"$f":"SUM(I54)","v":0},null,{"$f":"SUM(K54)","v":0},null,{"$f":"SUM(M54)","v":0},null,"Disclosures",null,"Line 563",null,"Line 203"]
[]
[]
[{"$nulls":6},"Total:",null,{"$f":"SUM(I64:I65)","v":0},null,{"$f":"SUM(K64:K65)","v":0},null,{"$f":"SUM(M64:M65)","v":0}]

{"sheet":"Sch. 5","index":11,"n_rows":60,"n_cols":18,"rows_kept":60,"merged":[[2,0,2,11],[5,2,5,10],[6,2,7,2],[6,15,6,16],[20,15,20,16],[24,2,24,10],[25,2,26,2],[33,15,33,16],[43,2,43,10],[44,2,45,2],[52,15,52,16]]}
[{"$nulls":11},"Schedule 5"]
[]
["Other Statement of Position Accounts"]
[]
[]
[null,null,"Accounts Payable"]
[null,null,"Description",null,"Church &",null,"School &",{"$nulls":8},"Instructions",null,"\"Schedule 5 - Other Statement of Position Accounts\" is"]
[{"$nulls":4},"Rectory",null,"Convent",null,"Cemetery",null,"Total",null,null,"Reference",null,"divided into three sections which are intended to provide itemized details of the"]
[{"$nulls":15},"totals reported on Lines 200 (Accounts Payable), 207 (Deferred Revenue), and 209"]
[1,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E10:I10)","v":0},null,null,"-",null,"(Other Liabilities).  As each section is completed, totals will automatically populate"]
[2,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E11:I11)","v":0},null,null,"-",null,"to the correct places on the Statement of Financial Position, as indicated in the"]
[3,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-",null,"Reference column."]
[4,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E13:I13)","v":0},null,null,"-"]
[5,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E14:I14)","v":0},null,null,"-",null,"Each liability should be reported as a separate line item.  If more space is needed,"]
[6,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E15:I15)","v":0},null,null,"-",null,"indicate \"See Attached Schedule\" on the description line, enter totals, and forward"]
[7,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-",null,"an itemized schedule providing details.  Parishes should only report liabilities on "]
[8,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-",null,"Schedule 5 which do not fit in other categories on the Statement of Financial Position."]
[9,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-"]
[10,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E19:I19)","v":0},null,null,"-",null,"Please provide descriptions beyond miscellaneous, various, assorted, etc."]
[]
[{"$nulls":15},"Note",null,"Report the balance of funds owed to third parties for goods or "]
[null,null,"Total Accounts Payable @ 06/30/22:",null,{"$f":"SUM(E10:E21)","v":0},null,{"$f":"SUM(G10:G21)","v":0},null,{"$f":"SUM(I10:I21)","v":0},null,{"$f":"SUM(K10:K21)","v":0},null,null,"Line 200",null,"services received by the Parish but not yet paid for as Accounts Payable.  Include any"]
[{"$nulls":15},"amounts from Schedule 6 which have been received in collections but which have not"]
[{"$nulls":15},"yet been disbursed to the final recipients."]
[null,null,"Deferred Revenue"]
[null,null,"Description",null,"Church &",null,"School &"]
[{"$nulls":4},"Rectory",null,"Convent",null,"Cemetery",null,"Total",null,null,"Reference"]
[]
[1,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E29:I29)","v":0},null,null,"-"]
[2,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E30:I30)","v":0},null,null,"-"]
[3,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E31:I31)","v":0},null,null,"-"]
[4,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E32:I32)","v":0},null,null,"-"]
[5,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-"]
[6,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E34:I34)","v":0},null,null,"-",null,"Note",null,"Report funds received by the Parish which have not yet been"]
[7,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E35:I35)","v":0},null,null,"-",null,"earned as Deferred Revenue.  Examples include monies received for the payment of"]
[8,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-",null,"upcoming religious education instruction or next semester's school tuition.  Revenues"]
[9,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-",null,"are later recognized in the Statement of Activities during the period in which they are"]
[10,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-",null,"earned."]
[{"$nulls":13},"-"]
[{"$nulls":15},"The Parish must have cash on hand to offset all Deferred Revenue reported here."]
[null,null,"Total Deferred Revenue @ 06/30/22:",null,{"$f":"SUM(E29:E40)","v":0},null,{"$f":"SUM(G29:G40)","v":0},null,{"$f":"SUM(I29:I40)","v":0},null,{"$f":"SUM(K29:K40)","v":0},null,null,"Line 207"]
[{"$nulls":15},"Do not include any \"reserves\" of Parish funds, which should be reported on Line 209"]
[{"$nulls":15},"(Other Liabilities) using the final section of this schedule."]
[null,null,"Other Liabilities"]
[null,null,"Description",null,"Church &",null,"School &"]
[{"$nulls":4},"Rectory",null,"Convent",null,"Cemetery",null,"Total",null,null,"Reference"]
[]
[1,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E48:I48)","v":0},null,null,"-"]
[2,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E49:I49)","v":0},null,null,"-"]
[3,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E50:I50)","v":0},null,null,"-"]
[4,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E51:I51)","v":0},null,null,"-"]
[5,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-"]
[6,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E53:I53)","v":0},null,null,"-",null,"Note",null,"Report funds designated by Parish management for specific"]
[7,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E54:I54)","v":0},null,null,"-",null,"purposes, as well as funds held in trust for Parish organizations, as Other Liabilities.  "]
[8,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-"]
[9,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-",null,"The Parish must have cash on hand to offset all liabilities reported here."]
[10,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-"]
[{"$nulls":15},"Do not include any funds owed to third parties for goods or services received, which "]
[{"$nulls":15},"should be reported on Line 200 (Accounts Payable) using the first section of this "]
[null,null,"Total Other Liabilities @ 06/30/22:",null,{"$f":"SUM(E48:E59)","v":0},null,{"$f":"SUM(G48:G59)","v":0},null,{"$f":"SUM(I48:I59)","v":0},null,{"$f":"SUM(K48:K59)","v":0},null,null,"Line 209",null,"schedule."]

{"sheet":"Sch. 6","index":12,"n_rows":42,"n_cols":18,"rows_kept":42,"merged":[[2,1,2,7],[5,1,5,7],[6,3,6,5],[6,12,6,13],[8,3,8,5],[9,3,9,5],[10,3,10,5],[11,3,11,5],[21,1,21,7],[22,3,22,5],[22,12,22,13],[24,3,24,5],[25,3,25,5],[26,3,26,5],[27,3,27,5],[28,3,28,5],[28,12,28,15],[28,17,28,19],[29,3,29,5],[29,17,29,19],[30,3,30,5],[30,17,30,19],[31,3,31,5],[31,17,31,19],[32,3,32,5],[32,17,32,19],[33,3,33,5],[33,17,33,19],[34,17,34,19],[35,17,35,19],[36,17,36,19],[37,17,37,19],[38,17,38,19],[39,17,39,19],[40,17,40,19],[41,17,41,19]]}
[{"$nulls":8},"Schedule 6"]
[]
[null,"Special Weekend Collections"]
[]
[]
[null,"Diocesan Collections"]
[null,"Number",null,"Description",{"$nulls":3},"Amount",null,null,"Reference",null,"Instructions",null,"\"Schedule 6 - Special Weekend Collections\" lists trust"]
[{"$nulls":12},"accounts for funds which are held in escrow for an eventual final recipient."]
[null,1,null,"Together in Charity",{"$nulls":3},0,null,null,"-"]
[null,2,null,"Foundation for Catholic Education",{"$nulls":3},0,null,null,"-",null,"The collections listed here are detailed in the documents \"Schedule of (Diocesan/"]
[null,3,null,"Catholic Press Month",{"$nulls":3},0,null,null,"-",null,"non-Diocesan) Collections” which are available on the Diocese's website.  The"]
[null,4,null,"Retirement Collection for Diocesan Clergy",{"$nulls":3},0,null,null,"-",null,"document covers a calendar year."]
[null,"-",null,"Other:",{"$nulls":3},0,null,null,"-"]
[null,"-",null,"Other:",{"$nulls":3},0,null,null,"-",null,"The 2017 document describes the collections for the first half of the fiscal year and"]
[null,"-",null,"Other:",{"$nulls":3},0,null,null,"-",null,"the 2018 document describes the collections for the second half of the fiscal year. "]
[]
[{"$nulls":10},"Line 429",null,"A summary of the documents is presented below to assist Parishes with reporting"]
[{"$nulls":5},"Total Diocesan Collections:",null,{"$f":"SUM(H9:H16)","v":0},null,null,"Line 565",null,"collections on the correct line of this schedule.  "]
[]
[{"$nulls":12},"Please enter a brief description for any items reported as “Other” Diocesan"]
[{"$nulls":12},"Collections or National & Missionary Appeals."]
[null,"National & Missionary Appeals"]
[null,"Number",null,"Description",{"$nulls":3},"Amount",null,null,"Reference",null,"Note",null,"Parishes should record the revenue, expense, and a"]
[{"$nulls":12},"corresponding liability in their books as special collections are taken.  When the"]
[null,5,null,"The Holy Land Collection",{"$nulls":3},0,null,null,"-",null,"collection is remitted to the final recipient, the Parish should reverse the liability. If"]
[null,6,null,"Catholic Relief Services",{"$nulls":3},0,null,null,"-",null,"funds have been collected but not disbursed, the liability created upon their"]
[null,7,null,"Development of the People",{"$nulls":3},0,null,null,"-",null,"collection should be reported on Line 200 by making an entry on Schedule 5."]
[null,8,null,"Catholic Communication Campaign",{"$nulls":3},0,null,null,"-"]
[null,9,null,"Peter's Pence Collection",{"$nulls":3},0,null,null,"-",null,"Description of Collection",{"$nulls":4},"Collected "]
[null,10,null,"Campaign for Human Development",{"$nulls":3},0,null,null,"-",null,"**","The Mission Cooperative Plan",{"$nulls":3},"Before last weekend in August"]
[null,11,null,"Retirement Fund for the Religious",{"$nulls":3},0,null,null,"-",null,9,"Peter’s  Pence  Collection",{"$nulls":3},"September 9 & 10, 2017"]
[null,"**",null,"World Mission Sunday",{"$nulls":3},0,null,null,"-",null,"**","World Mission Sunday",{"$nulls":3},"October 22, 2017"]
[null,"**",null,"Mission Cooperative Plan",{"$nulls":3},0,null,null,"-",null,10,"Campaign for Human Development ",{"$nulls":3},"Weekend before Thanksgiving"]
[null,"-",null,"Rice Bowl Collection",{"$nulls":3},0,null,null,"-",null,11,"Retirement Fund for Religious",{"$nulls":3},"December 2 & 3, 2017"]
[null,"-",null,"Other:",{"$nulls":3},0,null,null,"-",null,1,"Together in Charity",{"$nulls":3},"January 6 & 7, 2018"]
[null,"-",null,"Other:",{"$nulls":3},0,null,null,"-",null,2,"Foundation for Catholic Education ",{"$nulls":3},"January 20 & 21, 2018"]
[null,"-",null,"Other:",{"$nulls":3},0,null,null,"-",null,3,"Catholic  Press  Month",{"$nulls":3},"Month of February"]
[null,"-",null,"Other:",{"$nulls":3},0,null,null,"-",null,4,"Retirement  for  Diocesan  Clergy",{"$nulls":3},"Palm  Sunday"]
[{"$nulls":12},5,"The Holy Land Collection",{"$nulls":3},"Good Friday"]
[{"$nulls":10},"Line 431",null,6,"Catholic Relief Services",{"$nulls":3},"April 14 & 15, 2018"]
[{"$nulls":5},"Total National & Missionary Appeals:",null,{"$f":"SUM(H25:H40)","v":0},null,null,"Line 566",null,7,"Development of the People",{"$nulls":3},"April 28 & 29, 2018"]
[{"$nulls":12},8,"Catholic  Communication  Campaign",{"$nulls":3},"May 5 & 6, 2018"]

{"sheet":"Sch. 7","index":13,"n_rows":51,"n_cols":18,"rows_kept":51,"merged":[[2,0,2,11],[5,2,5,10],[6,2,7,2],[6,15,6,16],[22,15,22,16],[29,2,29,10],[30,2,31,2],[45,15,45,16],[48,15,49,16],[48,17,48,19],[48,20,48,22],[49,17,49,22],[53,15,53,16]]}
[{"$nulls":11},"Schedule 7"]
[]
["Other Statement of Activity Accounts"]
[]
[]
[null,null,"Other Revenue"]
[null,null,"Description",null,"Church &",null,"School &",{"$nulls":8},"Instructions",null,"\"Schedule 7 - Other Statement of Activity Accounts\" is"]
[{"$nulls":4},"Rectory",null,"Convent",null,"Cemetery",null,"Total",null,null,"Reference",null,"divided into two sections which are intended to provide itemized details of the"]
[{"$nulls":15},"totals reported on Lines 454 (Other Revenue) and 572 (Other Fixed Expenses)."]
[1,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E10:I10)","v":0},null,null,"-",null,"As each section is completed, totals will automatically populate to the correct"]
[2,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E11:I11)","v":0},null,null,"-",null,"places on the Statement of Financial Position, as indicated in the Reference"]
[3,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E12:I12)","v":0},null,null,"-",null,"column."]
[4,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-"]
[5,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-",null,"Each category of revenue or expense should be itemized."]
[6,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-"]
[7,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-",null,"If more space is needed, indicate \"See Attached Schedule\" on the description"]
[8,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E17:I17)","v":0},null,null,"-",null,"line, enter totals, and forward an itemized schedule providing details.  Parishes"]
[9,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-",null,"should only report revenues and expenses on Schedule 7 which do not fit in "]
[10,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E19:I19)","v":0},null,null,"-",null,"other categories on the Statement of Activities."]
[11,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-"]
[12,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-",null,"Please provide descriptions beyond miscellaneous, various, assorted, etc.…"]
[13,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E22:I22)","v":0},null,null,"-"]
[14,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-",null,"Note",null,"Line 454 (Other Revenue) has historically been an"]
[15,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-",null,"account where many Parishes have made reporting errors."]
[{"$nulls":15},"-","Collections should never be reported here.  Collections may be"]
[{"$nulls":16},"reported on Line 425 (Authorized Collections) with written"]
[null,null,"Total Other Revenue @ 06/30/22:",null,{"$f":"SUM(E10:E26)","v":0},null,{"$f":"SUM(G10:G26)","v":0},null,{"$f":"SUM(I10:I26)","v":0},null,{"$f":"SUM(K10:K26)","v":0},null,null,"Line 454",null,null,"permission from the Bishop.  All other collections must be reported"]
[{"$nulls":16},"on Lines 400-403 or Schedule 6 - Special Weekend Collections."]
[{"$nulls":15},"-","Expenses should never be netted with revenues here."]
[null,null,"Other Fixed Expenses"]
[null,null,"Description",null,"Church &",null,"School &",{"$nulls":8},"Donations given with a stipulation that they be utilized for a specific purpose"]
[{"$nulls":4},"Rectory",null,"Convent",null,"Cemetery",null,"Total",null,null,"Reference",null,"within the Parish may be reported here.  The Parish should retain documentation"]
[{"$nulls":15},"supporting the designation of these gifts, which will be requested by the"]
[1,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E34:I34)","v":0},null,null,"-",null,"Diocesan Internal Audit Department during their next review."]
[2,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E35:I35)","v":0},null,null,"-"]
[3,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E36:I36)","v":0},null,null,"-"]
[4,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E37:I37)","v":0},null,null,"-"]
[5,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E38:I38)","v":0},null,null,"-"]
[6,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-"]
[7,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-"]
[8,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-"]
[9,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-"]
[10,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E43:I43)","v":0},null,null,"-"]
[11,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E44:I44)","v":0},null,null,"-"]
[12,{"$nulls":3},0,null,0,null,0,null,{"$f":"SUM(E45:I45)","v":0},null,null,"-"]
[13,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-"]
[14,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-"]
[15,{"$nulls":3},0,null,0,null,0,null,0,null,null,"-"]
[]
[]
[null,null,"Total Other Expenses @ 06/30/22:",null,{"$f":"SUM(E34:E50)","v":0},null,{"$f":"SUM(G34:G50)","v":0},null,{"$f":"SUM(I34:I50)","v":0},null,{"$f":"SUM(K34:K50)","v":0},null,null,"Line 572"]

{"sheet":"Sch. 8","index":14,"n_rows":46,"n_cols":18,"rows_kept":46,"merged":[[2,1,2,11],[4,1,4,11],[5,1,5,11],[9,15,9,16],[21,15,21,16],[35,15,35,16],[38,15,39,16],[38,17,38,19],[38,20,38,22],[39,17,39,22],[43,15,43,16]]}
[{"$nulls":11},"Schedule 8"]
[]
[null,"Prior Year Worksheet"]
[]
[null,"Statement of Position from the 2020-2021 "]
[null,"\"Parish Financial Statement & Report\""]
[]
[{"$nulls":5},"Church &",null,"School &"]
[{"$nulls":5},"Rectory",null,"Convent",null,"Cemetery",null,"Total",null,"Reference"]
["2020-2021 Current Assets:",{"$nulls":14},"Instructions",null,"\"Schedule 8 - Prior Year Worksheet\" collects information"]
[null,100,null,"Cash",null,0,null,0,null,0,null,{"$f":"SUM(F11:J11)","v":0},null,"-",null,"about assets and liabilities from the previous fiscal year's Statement of Financial "]
[null,101,null,"Petty Cash",null,0,null,0,null,0,null,0,null,"-",null,"Position which is necessary in order for the statements to function properly."]
[null,102,null,"Investment Management Program",null,0,null,0,null,0,null,0,null,"-"]
[null,104,null,"External Investments",null,0,null,0,null,0,null,0,null,"-",null,"Enter last year’s balances as reported on the Statement of Position in the 2016-"]
[null,105,null,"Mortgages and Loans Receivable",null,0,null,0,null,0,null,{"$f":"SUM(F15:J15)","v":0},null,"-",null,"2017 Parish Financial Statement & Report. The schedule is organized in a similar "]
[null,107,null,"Accounts Receivable ",null,0,null,0,null,0,null,{"$f":"SUM(F16:J16)","v":0},null,"-",null,"layout to the Statement of Financial Position, and is split into Church, School,"]
[null,108,null,"Prepaid Expense",null,0,null,0,null,0,null,0,null,"-",null,"and Cemetery columns."]
[null,109,null,"Scrip Inventory",null,0,null,0,null,0,null,0,null,"-"]
[{"$nulls":15},"As each section is completed, totals will automatically populate to the correct"]
["2020-2021 Fixed Assets:",{"$nulls":14},"places on the Statements, as indicated in the Reference column."]
[null,110,null,"Land",null,0,null,0,null,0,null,{"$f":"SUM(F21:J21)","v":0},null,"Line 110"]
[null,111,null,"Buildings",null,0,null,0,null,0,null,{"$f":"SUM(F22:J22)","v":0},null,"Line 111",null,"Note",null,"Any adjustments made during the review of your Parish"]
[null,112,null,"Building Improvements",null,0,null,0,null,0,null,{"$f":"SUM(F23:J23)","v":0},null,"Line 112",null,"Financial Statement & Report for the fiscal year ended June 30, 2017 must be"]
[null,113,null,"Vehicles",null,0,null,0,null,0,null,{"$f":"SUM(F24:J24)","v":0},null,"Line 113",null,"reflected on this schedule."]
[null,114,null,"Furniture & Equipment",null,0,null,0,null,0,null,{"$f":"SUM(F25:J25)","v":0},null,"Line 114"]
[]
["2020-2021 Accumulated Depreciation:"]
[null,115,null,"Buildings",null,0,null,0,null,0,null,{"$f":"SUM(F28:J28)","v":0},null,"Line 115"]
[null,116,null,"Building Improvements",null,0,null,0,null,0,null,{"$f":"SUM(F29:J29)","v":0},null,"Line 116"]
[null,117,null,"Vehicles",null,0,null,0,null,0,null,{"$f":"SUM(F30:J30)","v":0},null,"Line 117"]
[null,118,null,"Furniture & Equipment",null,0,null,0,null,0,null,{"$f":"SUM(F31:J31)","v":0},null,"Line 118"]
[]
["2020-2021 Liabilities:"]
[null,200,null,"Miscellaneous Accounts Payable",null,0,null,0,null,0,null,{"$f":"SUM(F34:J34)","v":0},null,"-"]
[null,201,null,"Assessments Payable",null,0,null,0,null,0,null,{"$f":"SUM(F35:J35)","v":0},null,"-"]
[null,202,null,"Mortgages and Loans Payable",null,0,null,0,null,0,null,0,null,"-"]
[null,203,null,"IMP Loans Payable",null,0,null,0,null,0,null,0,null,"-"]
[null,204,null,"Stipends Payable",null,0,null,0,null,0,null,0,null,"-"]
[null,205,null,"Pension Contribution Payable",null,0,null,0,null,0,null,0,null,"-"]
[null,206,null,"Insurance Payable",null,0,null,0,null,0,null,0,null,"-"]
[null,207,null,"Deferred Revenue",null,0,null,0,null,0,null,0,null,"-"]
[null,208,null,"Payroll Liabilities",null,0,null,0,null,0,null,{"$f":"SUM(F42:J42)","v":0},null,"-"]
[null,209,null,"Other Liabilities",null,0,null,0,null,0,null,{"$f":"SUM(F43:J43)","v":0},null,"-"]
[]
[]
[{"$nulls":3},"2020-2021 Ending Net Assets:",null,{"$f":"SUM(F11:F31)-SUM(F34:F43)","v":0},null,{"$f":"SUM(H11:H31)-SUM(H34:H43)","v":0},null,{"$f":"SUM(J11:J31)-SUM(J34:J43)","v":0},null,{"$f":"SUM(L11:L31)-SUM(L34:L43)","v":0},null,"Disclosures"]

{"sheet":"Accounting_Review","index":15,"n_rows":116,"n_cols":183,"rows_kept":116,"merged":[[0,1,0,10],[1,1,1,10],[2,1,2,10],[5,14,5,18],[6,2,6,10],[21,2,22,8],[24,14,24,18],[25,2,26,8],[28,2,29,8],[31,2,32,8],[35,2,36,8],[38,2,39,8],[41,2,42,8],[45,2,47,8],[46,14,46,18],[49,2,50,8],[52,2,53,8],[56,2,57,8],[58,14,58,18],[60,2,61,8]]}
[null,"Financial Statement Review Form",{"$nulls":10},"Parish ID",null,"Values Sent to Access",null,"Original",null,"Override (9XX)",{"$nulls":6},"Send to Access:","ID","Parish_IDFK","FYE","100","101","102","104","105","107","108","109","110","115","195","199","200","201","202","203","204","205","206","207","208","209","299","300","400","401","402","403","405","406","410","411","418","420","424","425","426","427","428","429","431","432","433","440","441","442","443","444","445","447","450","451","452","453","454","460","497","498","499","500","501","502","502-1","502-2","502-3","502-4","503","504","505","506","507","508","510","511","512","513","514","515","516","517","518","519","520","521","522","523","524","525","526","527","528","529","540","541","542","543","545","546","547","548","550","551","552","553","554","555","557","558","559","560","561","562","563","564","565","566","567","568","569","570","571","572","573","593","594","595","596","597","598","599","901","902","903","904","905","906","907","908","909","910","911","912","913","914","915","916","917","918","919","996","997","998","999","FINAL"]
[null,{"$f":"Cover!E9&\", \"&Cover!E11&\" (\"&TEXT(Accounting_Review!M2-20000,\"000\")&\")\"","v":"-, - (032)"},{"$nulls":10},20032,null,"Deductible Rent (410/996)",null,{"$f":"'Activities 1'!L20","v":0},null,{"$f":"Q2","v":0},{"$nulls":7},{"$f":"AB2","v":20032},{"$f":"M2","v":20032},{"$f":"M5","v":2018},{"$f":"Position!F$10","v":{"v":0,"d":"$0.00"}},{"$f":"Position!F$11","v":{"v":0,"d":"$0.00"}},{"$f":"Position!F$12","v":{"v":0,"d":"$0.00"}},{"$f":"Position!F$13","v":{"v":0,"d":"$0.00"}},{"$f":"Position!F$14","v":{"v":0,"d":"$0.00"}},{"$f":"Position!F$15","v":{"v":0,"d":"$0.00"}},{"$f":"Position!F$16","v":{"v":0,"d":"$0.00"}},{"$f":"Position!F$17","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(Position!F$20:F$24)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(Position!F$27:F$30)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"$f":"Position!F$33","v":{"v":0,"d":"$0.00"}},{"$f":"Position!F$36","v":{"v":0,"d":"$0.00"}},{"$f":"Position!F$37","v":{"v":0,"d":"$0.00"}},{"$f":"Position!F$38","v":{"v":0,"d":"$0.00"}},{"$f":"Position!F$39","v":{"v":0,"d":"$0.00"}},{"$f":"Position!F$40","v":{"v":0,"d":"$0.00"}},{"$f":"Position!F$41","v":{"v":0,"d":"$0.00"}},{"$f":"Position!F$42","v":{"v":0,"d":"$0.00"}},{"$f":"Position!F$43","v":{"v":0,"d":"$0.00"}},{"$f":"Position!F$44","v":{"v":0,"d":"$0.00"}},{"$f":"Position!F$45","v":{"v":0,"d":"$0.00"}},{"$f":"Position!F$48","v":{"v":0,"d":"$0.00"}},{"$f":"Position!F$50","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$10","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$11","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$12","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$13","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$18","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$19","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$20","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$21","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$22","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$30","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$31","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$32","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$33","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$34","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$35","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$36","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$37","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$38","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$39","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$40","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$41","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$42","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$43","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$44","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"$f":"'Activities 1'!F$45","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$46","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$47","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$48","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$49","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$50","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$51","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$27","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$54","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!F$56","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$10","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$11","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$12","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$13","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$14","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$15","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$16","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$17","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$18","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$19","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$20","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$21","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$22","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$23","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$29","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$30","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$31","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$32","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$33","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$34","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$35","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$36","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$37","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$43","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$44","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$45","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$46","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$47","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$48","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$49","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$50","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$51","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$52","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$10","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"$f":"'Activities 3'!F$11","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$12","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$13","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$14","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$15","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$16","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$22","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$23","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$24","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$25","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$26","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$27","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"'Activities 3'!F$33","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$34","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$35","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$36","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$37","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$38","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$39","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$40","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$41","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$42","v":{"v":0,"d":"$0.00"}},{"$f":"SUM('Activities 3'!F$43:F$46)","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$30","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$26","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$40","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!F$55","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$19","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$49","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!F$51","v":{"v":0,"d":"$0.00"}},{"$f":"Cover!$G$15","v":0},{"$f":"Cover!$G$17","v":0},{"$f":"Disclosures!$V$65","v":0},{"$f":"Disclosures!$V$66","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"S2","v":0},{"$f":"S3","v":0},{"$f":"S4","v":0},{"$f":"'Activities 3'!F$53","v":{"v":0,"d":"$0.00"}},{"$f":"$M$8","v":true}]
[null,"FYE June 30, 2022",{"$nulls":12},"Loan Principle (Sch. 4/997)",null,{"$f":"'Sch. 4'!I20","v":0},null,{"$f":"Q3","v":0},{"$nulls":7},{"$f":"AB3+10000","v":30032},{"$f":"M2","v":20032},{"$f":"M5","v":2018},{"$f":"Position!H$10","v":{"v":0,"d":"$0.00"}},{"$f":"Position!H$11","v":{"v":0,"d":"$0.00"}},{"$f":"Position!H$12","v":{"v":0,"d":"$0.00"}},{"$f":"Position!H$13","v":{"v":0,"d":"$0.00"}},{"$f":"Position!H$14","v":{"v":0,"d":"$0.00"}},{"$f":"Position!H$15","v":{"v":0,"d":"$0.00"}},{"$f":"Position!H$16","v":{"v":0,"d":"$0.00"}},{"$f":"Position!H$17","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(Position!H$20:H$24)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(Position!H$27:H$30)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"$f":"Position!H$33","v":{"v":0,"d":"$0.00"}},{"$f":"Position!H$36","v":{"v":0,"d":"$0.00"}},{"$f":"Position!H$37","v":{"v":0,"d":"$0.00"}},{"$f":"Position!H$38","v":{"v":0,"d":"$0.00"}},{"$f":"Position!H$39","v":{"v":0,"d":"$0.00"}},{"$f":"Position!H$40","v":{"v":0,"d":"$0.00"}},{"$f":"Position!H$41","v":{"v":0,"d":"$0.00"}},{"$f":"Position!H$42","v":{"v":0,"d":"$0.00"}},{"$f":"Position!H$43","v":{"v":0,"d":"$0.00"}},{"$f":"Position!H$44","v":{"v":0,"d":"$0.00"}},{"$f":"Position!H$45","v":{"v":0,"d":"$0.00"}},{"$f":"Position!H$48","v":{"v":0,"d":"$0.00"}},{"$f":"Position!H$50","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$10","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$11","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$12","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$13","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$18","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$19","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$20","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$21","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$22","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$30","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$31","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$32","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$33","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$34","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$35","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$36","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$37","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$38","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$39","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$40","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$41","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$42","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$43","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$44","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"$f":"'Activities 1'!H$45","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$46","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$47","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$48","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$49","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$50","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$51","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$27","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$54","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!H$56","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$10","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$11","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$12","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$13","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$14","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$15","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$16","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$17","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$18","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$19","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$20","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$21","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$22","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$23","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$29","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$30","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$31","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$32","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$33","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$34","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$35","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$36","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$37","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$43","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$44","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$45","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$46","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$47","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$48","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$49","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$50","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$51","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$52","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$10","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"$f":"'Activities 3'!H$11","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$12","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$13","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$14","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$15","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$16","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$22","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$23","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$24","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$25","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$26","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$27","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"'Activities 3'!H$33","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$34","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$35","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$36","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$37","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$38","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$39","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$40","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$41","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$42","v":{"v":0,"d":"$0.00"}},{"$f":"SUM('Activities 3'!H$43:H$46)","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$30","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$26","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$40","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!H$55","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$19","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$49","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!H$51","v":{"v":0,"d":"$0.00"}},0,0,0,0,{"$f":"$Q$7","v":0},{"$f":"$Q$8","v":0},{"$f":"$Q$9","v":0},{"$f":"$Q$10","v":0},{"$f":"$Q$11","v":0},{"$f":"$Q$12","v":0},{"$f":"$Q$13","v":0},{"$f":"$Q$14","v":0},{"$f":"$Q$15","v":0},{"$f":"$Q$16","v":0},{"$f":"$S$17","v":0},0,0,0,0,0,0,0,{"$f":"'Activities 3'!H$53","v":{"v":0,"d":"$0.00"}},{"$f":"$M$8","v":true}]
[{"$nulls":12},2018,null,"Loan Interest (563/998)",null,{"$f":"'Activities 3'!F33","v":0},null,{"$f":"Q4","v":0},{"$nulls":7},{"$f":"AB4+20000","v":40032},{"$f":"M2","v":20032},{"$f":"M5","v":2018},{"$f":"Position!J$10","v":{"v":0,"d":"$0.00"}},{"$f":"Position!J$11","v":{"v":0,"d":"$0.00"}},{"$f":"Position!J$12","v":{"v":0,"d":"$0.00"}},{"$f":"Position!J$13","v":{"v":0,"d":"$0.00"}},{"$f":"Position!J$14","v":{"v":0,"d":"$0.00"}},{"$f":"Position!J$15","v":{"v":0,"d":"$0.00"}},{"$f":"Position!J$16","v":{"v":0,"d":"$0.00"}},{"$f":"Position!J$17","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(Position!J$20:J$24)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(Position!J$27:J$30)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"$f":"Position!J$33","v":{"v":0,"d":"$0.00"}},{"$f":"Position!J$36","v":{"v":0,"d":"$0.00"}},{"$f":"Position!J$37","v":{"v":0,"d":"$0.00"}},{"$f":"Position!J$38","v":{"v":0,"d":"$0.00"}},{"$f":"Position!J$39","v":{"v":0,"d":"$0.00"}},{"$f":"Position!J$40","v":{"v":0,"d":"$0.00"}},{"$f":"Position!J$41","v":{"v":0,"d":"$0.00"}},{"$f":"Position!J$42","v":{"v":0,"d":"$0.00"}},{"$f":"Position!J$43","v":{"v":0,"d":"$0.00"}},{"$f":"Position!J$44","v":{"v":0,"d":"$0.00"}},{"$f":"Position!J$45","v":{"v":0,"d":"$0.00"}},{"$f":"Position!J$48","v":{"v":0,"d":"$0.00"}},{"$f":"Position!J$50","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$10","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$11","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$12","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$13","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$18","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$19","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$20","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$21","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$22","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$30","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$31","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$32","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$33","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$34","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$35","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$36","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$37","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$38","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$39","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$40","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$41","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$42","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$43","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$44","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"$f":"'Activities 1'!J$45","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$46","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$47","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$48","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$49","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$50","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$51","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$27","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$54","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 1'!J$56","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$10","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$11","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$12","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$13","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$14","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$15","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$16","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$17","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$18","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$19","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$20","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$21","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$22","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$23","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$29","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$30","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$31","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$32","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$33","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$34","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$35","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$36","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$37","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$43","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$44","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$45","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$46","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$47","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$48","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$49","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$50","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$51","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$52","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$10","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"$f":"'Activities 3'!J$11","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$12","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$13","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$14","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$15","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$16","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$22","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$23","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$24","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$25","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$26","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$27","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"'Activities 3'!J$33","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$34","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$35","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$36","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$37","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$38","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$39","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$40","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$41","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$42","v":{"v":0,"d":"$0.00"}},{"$f":"SUM('Activities 3'!J$43:J$46)","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$30","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$26","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$40","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 2'!J$55","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$19","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$49","v":{"v":0,"d":"$0.00"}},{"$f":"'Activities 3'!J$51","v":{"v":0,"d":"$0.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"'Activities 3'!J$53","v":{"v":0,"d":"$0.00"}},{"$f":"$M$8","v":true}]
[{"$nulls":12},2018]
["Comments:",{"$nulls":11},{"$f":"M5-1","v":2017},null,"School Enrollment",{"$nulls":10},"Enrollment Review:","ID","Parish_IDFK","FYE","905C","906C","907C","908C","909C","910C","911C","912C","913C","914C","915C","916C","917C","918C","919C"]
[null,null,{"$f":"IF(M8=FALSE,\"PRELIMINARY:  please address the errors noted below and resubmit the report.\",\"FINAL:  the report has been accepted.\")","v":"FINAL:  the report has been accepted."},{"$nulls":9},"Final?",null,"Pre-K",null,{"$f":"AD7","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "}]
[{"$nulls":12},true,null,"Kindergarten",null,{"$f":"AE7","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "}]
[{"$nulls":14},"First",null,{"$f":"AF7","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"$nulls":6},"IMP Review:","® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ®"]
[{"$nulls":14},"Second",null,{"$f":"AG7","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"$nulls":6},"P&L / Assessment Review:","ID","Parish_IDFK","FYE","Bill_Type","Trans_Type","Invoice","Ref","Trans_Date","Amount",null,"IMP Review:","ID","Parish_IDFK","FYE","Act_Type","Act_Num","Trans_Date","Trans_Type","Amount"]
[{"$nulls":5},"DO NOT USE!",{"$nulls":8},"Third",null,{"$f":"AH7","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"$nulls":7},"20032",20032,"2018","AS","ARB","17032AS","N/A","2017-07-01",{"v":27200,"d":"$27,200.00"}]
[{"$nulls":14},"Fourth",null,{"$f":"AI7","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},null,null,"LY 300:","Unit","Amount",null,null,"20032",20032,"2018","AS","BB","N/A","N/A","2017-07-01",{"v":0,"d":"$0.00"}]
[{"$nulls":14},"Fifth",null,{"$f":"AJ7","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"$nulls":3},"Church",{"v":582712,"d":"$582,712"},null,null,"20032",20032,"2018","AS","ARC","17032AS","3475","2017-10-05",{"v":-2720,"d":"-$2,720.00"}]
[{"$nulls":14},"Sixth",null,{"$f":"AK7","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"$nulls":3},"School",{"$nulls":3},"20032",20032,"2018","AS","ARC","17032AS","3508","2017-11-09",{"v":-2720,"d":"-$2,720.00"}]
[{"$nulls":14},"Seventh",null,{"$f":"AL7","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"$nulls":3},"Cemetery",{"$nulls":3},"20032",20032,"2018","AS","ARC","17032AS","3522","2017-12-06",{"v":-5440,"d":"-$5,440.00"}]
["Cover Page:",{"$nulls":13},"Eighth",null,{"$f":"AM7","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"$nulls":7},"20032",20032,"2018","AS","ARC","17032AS","3537","2018-01-08",{"v":-2720,"d":"-$2,720.00"}]
["1)",null,{"$f":"IF(AND(Cover!G15>0,Cover!G17>0),\"The Parish has provided the number of registered families and registered Catholics.\",IF(AND(Cover!G15>0,Cover!G17=0),\"The Parish has provided the number of registered families but not the number of registered Catholics.\",IF(AND(Cover!G15=0,Cover!G17>0),\"The Parish has provided the number of registered Catholics but not the number of registered families.\",\"The Parish has not provided the number of registered Catholics or registered families.\")))","v":"The Parish has not provided the number of registered Catholics or registered families."},{"$nulls":7},{"$f":"IF(AND(Cover!G15>0,Cover!G17>0),\"OK\",\"Error\")","v":"Error"},{"$nulls":3},"Ninth",null,{"v":0,"d":"0 "},null,{"$f":"AN8","v":{"v":0,"d":"0 "}},{"$nulls":3},"Total",{"$f":"SUM(X13:X15)","v":{"v":582712,"d":"$582,712"}},null,null,"20032",20032,"2018","AS","ARC","17032AS","3549","2018-02-05",{"v":-2720,"d":"-$2,720.00"}]
[{"$nulls":12},"Acknowldegements?",null,"Tenth",null,{"v":0,"d":"0 "},null,{"$f":"AO8","v":{"v":0,"d":"0 "}},{"$nulls":7},"20032",20032,"2018","AS","ARM","17032AS","N/A","2018-02-16",{"v":4100,"d":"$4,100.00"}]
["2)",null,{"$f":"IF(M19=FALSE,\"The Parish has not completed the acknowledgements on the cover of the report.\",\"The Parish has submitted a report with signed acknowledgements.\")","v":"The Parish has not completed the acknowledgements on the cover of the report."},{"$nulls":7},{"$f":"IF(M19=FALSE,\"Error\",\"OK\")","v":"Error"},null,false,null,"Eleventh",null,{"v":0,"d":"0 "},null,{"$f":"AP8","v":{"v":0,"d":"0 "}},{"$nulls":7},"20032",20032,"2018","AS","ARC","17032AS","3561","2018-03-12",{"v":-2720,"d":"-$2,720.00"}]
[{"$nulls":14},"Twelfth",null,{"v":0,"d":"0 "},null,{"$f":"AQ8","v":{"v":0,"d":"0 "}},{"$nulls":7},"20032",20032,"2018","AS","ARC","17032AS","3575","2018-04-06",{"v":-2720,"d":"-$2,720.00"}]
["Assets:",{"$nulls":11},102,{"$nulls":13},"20032",20032,"2018","AS","ARC","17032AS","3593","2018-05-08",{"v":-2720,"d":"-$2,720.00"}]
["3)",null,{"$f":"\"Line 102 (Diocesan Investment Mgmt. Program):  \"&IF(ABS(Position!L12-M22)<1,\"the Parish reported \"&TEXT(Position!L12,\"$#,##0\")&\", which is in agreement with Diocesan records.\",\"the Parish reported \"&TEXT(Position!L12,\"$#,##0\")&\", while Diocesan records indicate \"&TEXT(M22,\"$#,##0\")&\".  The difference is \"&TEXT(ABS(Position!L12-M22),\"$#,##0\")&\".\")","v":"Line 102 (Diocesan Investment Mgmt. Program):  the Parish reported $0, which is in agreement with Diocesan records."},{"$nulls":7},{"$f":"IF(ABS(Position!L12-M22)<1,\"OK\",\"Error\")","v":"OK"},null,{"$f":"S63","v":0},null,"Total",null,{"$f":"SUM(Q7:Q21)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(S17:S21)","v":0},{"$nulls":7},"20032",20032,"2018","AS","ARC","17032AS","3604","2018-06-08",{"v":-2720,"d":"-$2,720.00"}]
[{"$nulls":26},"20032",20032,"2018","AS","ARC","17032AS","3613","2018-06-25",{"v":-4100,"d":"-$4,100.00"}]
[{"$nulls":26},"20032",20032,"2018","ESA","ARB","17032ESA","N/A","2017-07-01",{"v":9300,"d":"$9,300.00"}]
["Liabilities:",{"$nulls":11},201,null,"Assessment Activity",{"$nulls":11},"20032",20032,"2018","ESA","ARC","17032ESA","3475","2017-10-05",{"v":-930,"d":"-$930.00"}]
["4)",null,{"$f":"\"Line 201 (Assessments Payable):  \"&IF(ABS(Position!L37-M26)<1,\"the Parish reported \"&TEXT(Position!L37,\"$#,##0\")&\", which is in agreement with Diocesan records.\",\"the Parish reported \"&TEXT(Position!L37,\"$#,##0\")&\", while Diocesan records indicate \"&TEXT(M26,\"$#,##0\")&\".  The difference is \"&TEXT(ABS(Position!L37-M26),\"$#,##0\")&\".\")","v":"Line 201 (Assessments Payable):  the Parish reported $0, which is in agreement with Diocesan records."},{"$nulls":7},{"$f":"IF(ABS(Position!L37-M26)<1,\"OK\",\"Error\")","v":"OK"},null,{"$f":"S44","v":0},null,{"$f":"\"Assessment Billings  @ 06/01/\"&$M$5-2001&\":\"","v":"Assessment Billings  @ 06/01/17:"},{"$nulls":11},"20032",20032,"2018","ESA","ARC","17032ESA","3508","2017-11-09",{"v":-930,"d":"-$930.00"}]
[{"$nulls":14},"Regular Assessment (AS)",null,{"$f":"SUMIFS($AI$11:$AI$60,$AD$11:$AD$60,\"AS\",$AE$11:$AE$60,\"ARB\")+SUMIFS($AI$11:$AI$60,$AD$11:$AD$60,\"AS\",$AE$11:$AE$60,\"ARM\")","v":{"v":31300,"d":"$31,300.00"}},{"$nulls":9},"20032",20032,"2018","ESA","ARC","17032ESA","3522","2017-12-06",{"v":-1860,"d":"-$1,860.00"}]
[{"$nulls":12},203,null,"School Assessment (ESA)",null,{"$f":"SUMIFS($AI$11:$AI$60,$AD$11:$AD$60,\"ESA\",$AE$11:$AE$60,\"ARB\")+SUMIFS($AI$11:$AI$60,$AD$11:$AD$60,\"ESA\",$AE$11:$AE$60,\"ARM\")","v":{"v":10700,"d":"10,700.00"}},{"$nulls":9},"20032",20032,"2018","ESA","ARC","17032ESA","3537","2018-01-08",{"v":-930,"d":"-$930.00"}]
["5)",null,{"$f":"\"Line 203 (Diocesan Loans Payable):  \"&IF(ABS(Position!L39-M29)<1,\"the Parish reported \"&TEXT(Position!L39,\"$#,##0\")&\", which is in agreement with Diocesan records.\",\"the Parish reported \"&TEXT(Position!L39,\"$#,##0\")&\", while Diocesan records indicate \"&TEXT(M29,\"$#,##0\")&\".  The difference is \"&TEXT(ABS(Position!L39-M29),\"$#,##0\")&\".\")","v":"Line 203 (Diocesan Loans Payable):  the Parish reported $0, which is in agreement with Diocesan records."},{"$nulls":7},{"$f":"IF(ABS(Position!L39-M29)<1,\"OK\",\"Error\")","v":"OK"},null,{"$f":"S65","v":0},null,"Rental Assessment (RA)","+",{"$f":"SUMIFS($AI$11:$AI$60,$AD$11:$AD$60,\"RA\",$AE$11:$AE$60,\"ARB\")+SUMIFS($AI$11:$AI$60,$AD$11:$AD$60,\"RA\",$AE$11:$AE$60,\"ARM\")","v":0},{"$nulls":9},"20032",20032,"2018","ESA","ARC","17032ESA","3549","2018-02-05",{"v":-930,"d":"-$930.00"}]
[{"$nulls":26},"20032",20032,"2018","ESA","ARM","17032ESA","N/A","2018-02-16",{"v":1400,"d":"$1,400.00"}]
[{"$nulls":12},206,null,"Total Assessments Billed:",{"$nulls":3},{"$f":"SUM(Q27:Q29)","v":{"v":42000,"d":"$42,000.00"}},{"$nulls":7},"20032",20032,"2018","ESA","ARC","17032ESA","3561","2018-03-12",{"v":-930,"d":"-$930.00"}]
["6)",null,{"$f":"\"Line 206 (Insurance Payable):  \"&IF(Position!L42=M33,\"the Parish reported \"&TEXT(Position!L42,\"$#,##0\")&\", which is in agreement with Diocesan records.\",\"the Parish reported \"&TEXT(Position!L42,\"$#,##0\")&\", while Diocesan records indicate \"&TEXT(M33,\"$#,##0\")&\".  The difference is \"&TEXT(ABS(Position!L42-M33),\"$#,##0\")&\".\")","v":"Line 206 (Insurance Payable):  the Parish reported $0, which is in agreement with Diocesan records."},{"$nulls":7},{"$f":"IF(Position!L42=M33,\"OK\",\"Error\")","v":"OK"},null,2017,{"$nulls":13},"20032",20032,"2018","ESA","ARC","17032ESA","3575","2018-04-06",{"v":-930,"d":"-$930.00"}]
[{"$nulls":12},{"$f":"IF(M32=M5,S56,S52)","v":0},null,{"$f":"\"Assessment BB @ 07/01/\"&$M$5-2001&\":\"","v":"Assessment BB @ 07/01/17:"},null,null,"+",{"$f":"SUMIFS($AI$11:$AI$60,$AD$11:$AD$60,\"AS\",$AE$11:$AE$60,\"BB\")+SUMIFS($AI$11:$AI$60,$AD$11:$AD$60,\"ESA\",$AE$11:$AE$60,\"BB\")+SUMIFS($AI$11:$AI$60,$AD$11:$AD$60,\"RA\",$AE$11:$AE$60,\"BB\")","v":0},{"$nulls":7},"20032",20032,"2018","ESA","ARC","17032ESA","3593","2018-05-08",{"v":-930,"d":"-$930.00"}]
[{"$nulls":26},"20032",20032,"2018","ESA","ARC","17032ESA","3604","2018-06-08",{"v":-930,"d":"-$930.00"}]
["Revenues:",{"$nulls":11},420,null,"Total Assessments Due:",{"$nulls":3},{"$f":"SUM(S31:S34)","v":{"v":42000,"d":"$42,000.00"}},{"$nulls":7},"20032",20032,"2018","ESA","BB","N/A","N/A","2018-06-25",{"v":0,"d":"$0.00"}]
["7)",null,{"$f":"\"Line 420 (IMP Interest Income):  \"&IF(ABS('Activities 1'!L30-M36)<1,\"the Parish reported \"&TEXT('Activities 1'!L30,\"$#,##0\")&\", which is in agreement with Diocesan records.\",\"the Parish reported \"&TEXT('Activities 1'!L30,\"$#,##0\")&\", while Diocesan records indicate \"&TEXT(M36,\"$#,##0\")&\".  The difference is \"&TEXT(ABS('Activities 1'!L30-M36),\"$#,##0\")&\".\")","v":"Line 420 (IMP Interest Income):  the Parish reported $0, which is in agreement with Diocesan records."},{"$nulls":7},{"$f":"IF(ABS('Activities 1'!L30-M36)<1,\"OK\",\"Error\")","v":"OK"},null,{"$f":"S61","v":0},{"$nulls":13},"20032",20032,"2018","ESA","ARC","17032ESA","3613","2018-06-25",{"v":-1400,"d":"-$1,400.00"}]
[{"$nulls":14},"Less Assessment Payments",{"$nulls":11},"20032",20032,"2018","P&L","BB","N/A","N/A","2017-07-01",{"v":24183,"d":"$24,183.00"}]
[{"$nulls":14},"Regular Assessment (AS)",null,{"$f":"SUMIFS($AI$11:$AI$60,$AD$11:$AD$60,\"AS\",$AE$11:$AE$60,\"ARC\")","v":{"v":-31300,"d":"$(31,300.00)"}},{"$nulls":9},"20032",20032,"2018","P&L","ARC","17032PL","3473","2017-10-05",{"v":-2418.3,"d":"-$2,418.30"}]
["8)",null,{"$f":"\"Line 425 (Authorized Collections):  \"&IF(AND('Activities 1'!L32>0,M40=FALSE),\"the Parish reported revenue, but has not received written approval from the Bishop.  This revenue must be reported on Line 400 (Weekend Collections).\",IF(AND('Activities 1'!L32>0,M40=TRUE),\"the Parish has reported revenue which they were authorized by the Bishop to collect.\",\"the Parish has not reported any revenue.\"))","v":"Line 425 (Authorized Collections):  the Parish has not reported any revenue."},{"$nulls":7},{"$f":"IF(AND('Activities 1'!L32>0,M40=FALSE),\"Error\",\"OK\")","v":"OK"},null,"Authorization?",null,"School Assessment (ESA)",null,{"$f":"SUMIFS($AI$11:$AI$60,$AD$11:$AD$60,\"ESA\",$AE$11:$AE$60,\"ARC\")","v":{"v":-10700,"d":"(10,700.00)"}},{"$nulls":9},"20032",20032,"2018","P&L","ARC","17032PL","3508","2017-11-09",{"v":-2418.3,"d":"-$2,418.30"}]
[{"$nulls":12},false,null,"Rental Assessment (RA)","+",{"$f":"SUMIFS($AI$11:$AI$60,$AD$11:$AD$60,\"RA\",$AE$11:$AE$60,\"ARC\")","v":0},{"$nulls":9},"20032",20032,"2018","P&L","ARC","17032PL","3522","2017-12-06",{"v":-4836.6,"d":"-$4,836.60"}]
[{"$nulls":12},"Lay Salaries",{"$nulls":13},"20032",20032,"2018","P&L","ARC","17032PL","3537","2018-01-08",{"v":-2418.3,"d":"-$2,418.30"}]
["9)",null,{"$f":"\"Lines 444 (School Subsidy from Parish) & 540 (Parish School Subsidy):  \"&IF(AND('Activities 1'!H56=0,'Activities 3'!H51=0),\"The Parish does not operate a School, and has not reported any subsidy revenue or expense.\",IF('Activities 1'!H44='Activities 3'!F10,\"The School reported subsidy revenue of \"&TEXT('Activities 1'!H44,\"$#,##0\")&\", which agrees with the subsidy expense reported by the Church.\",\"The School reported subsidy revenue of \"&TEXT('Activities 1'!H44,\"$#,##0\")&\", while the Church reported \"&TEXT('Activities 3'!F10,\"$#,##0\")&\" of subsidy expense.  The difference is \"&TEXT(ABS('Activities 1'!H44-'Activities 3'!F10),\"$#,##0\")&\".\"))","v":"Lines 444 (School Subsidy from Parish) & 540 (Parish School Subsidy):  The Parish does not operate a School, and has not reported any subsidy revenue or expense."},{"$nulls":7},{"$f":"IF('Activities 1'!H44='Activities 3'!F10,\"OK\",\"Error\")","v":"OK"},null,{"$f":"SUM('Activities 2'!L13:L16)","v":0},null,"Total Assessment Payments:",null,null,"+",{"$f":"SUM(Q38:Q40)","v":{"v":-42000,"d":"$(42,000.00)"}},{"$nulls":7},"20032",20032,"2018","P&L","ARC","17032PL","3549","2018-02-05",{"v":-2418.3,"d":"-$2,418.30"}]
[{"$nulls":12},"Expected FICA",{"$nulls":13},"20032",20032,"2018","P&L","ARC","17032PL","3561","2018-03-12",{"v":-2418.3,"d":"-$2,418.30"}]
[{"$nulls":12},{"$f":"M42*0.0765","v":0},null,{"$f":"\"Assessment Payable @ 06/30/\"&$M$5-2000&\":\"","v":"Assessment Payable @ 06/30/18:"},{"$nulls":3},{"$f":"SUM(S35:S43)","v":0},{"$nulls":7},"20032",20032,"2018","P&L","ARC","17032PL","3575","2018-04-06",{"v":-2418.3,"d":"-$2,418.30"}]
["Expenses:",{"$nulls":11},"reported FICA",{"$nulls":13},"20032",20032,"2018","P&L","ARC","17032PL","3593","2018-05-08",{"v":-2418.3,"d":"-$2,418.30"}]
["10)",null,{"$f":"\"Line 506 (Social Security:  Employer Portion):  the Parish reported \"&TEXT(M46,\"$#,##0\")&\".  The expected FICA expenses were \"&TEXT(M44,\"$#,##0\")&\" (Lay Salaries of \"&TEXT(M42,\"$#,##0\")&\" times the FICA rate of 7.65%).  The amount reported\"&IF((M46-M44)>5,\" exceeds the amount expected by \"&TEXT(M46-M44,\"$#,##0\")&\".  Please provide an explanation.\",IF((M44-M46)>(M44*0.1),\" is \"&TEXT(M44-M46,\"$#,##0\")&\" (\"&TEXT((M44-M46)/M44*100,\"0\")&\"%) less than expected.  Please provide an explanation.\",\" is reasonable compared to expectations.\"))","v":"Line 506 (Social Security:  Employer Portion):  the Parish reported $0.  The expected FICA expenses were $0 (Lay Salaries of $0 times the FICA rate of 7.65%).  The amount reported is reasonable compared to expectations."},{"$nulls":7},{"$f":"IF('Activities 2'!L20-(SUM('Activities 2'!L13:L16)*0.0765)>1,\"Error\",IF((((SUM('Activities 2'!L13:L16)*0.0765)-'Activities 2'!L20)/IF(SUM('Activities 2'!L13:L16)=0,0.00000001,(SUM('Activities 2'!L13:L16)*0.0765)))>0.1,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"'Activities 2'!L20","v":0},{"$nulls":13},"20032",20032,"2018","P&L","ARB","18032PL","N/A","2018-06-01",{"v":24693,"d":"$24,693.00"}]
[{"$nulls":14},"P&L Activity",{"$nulls":11},"20032",20032,"2018","P&L","ARC","17032PL","3604","2018-06-08",{"v":-2418.3,"d":"-$2,418.30"}]
[{"$nulls":12},524,null,{"$f":"\"P&L Beginning Balance @ 07/01/\"&$M$5-2001&\":\"","v":"P&L Beginning Balance @ 07/01/17:"},{"$nulls":3},{"$f":"SUMIFS($AI$11:$AI$60,$AD$11:$AD$60,\"P&L\",$AE$11:$AE$60,\"BB\")","v":{"v":24183,"d":"$24,183.00"}}]
[{"$nulls":12},2017]
["11)",null,{"$f":"\"Line 524 (Insurance):  the Parish reported \"&TEXT('Activities 2'!L47,\"$#,##0\")&\" of expenses, \"&IF(ABS('Activities 2'!L47-M50)<1,\"which is in agreement with Diocesan records.\",IF(AND('Activities 2'!L47>M50,ABS('Activities 2'!L47-M50)<(M50*0.25)),\"which slightly exceeds Diocesan records.\",IF(AND('Activities 2'!L47>M50,ABS('Activities 2'!L47-M50)>(M50*0.25)),\"which exceeds Diocesan records by \"&TEXT('Activities 2'!L47-M50,\"$#,##0\")&\" (\"&TEXT(ABS('Activities 2'!L47-M50)/M50*100,\"00\")&\"%).\",\"which is \"&TEXT(M50-'Activities 2'!L47,\"$#,##0\")&\" less than the amount billed by the Diocese.\")&\"  Please provide an explanation for the difference.\"))","v":"Line 524 (Insurance):  the Parish reported $0 of expenses, which is $24,183 less than the amount billed by the Diocese.  Please provide an explanation for the difference."},{"$nulls":7},{"$f":"IF('Activities 2'!L47<M50,\"Error\",IF(ABS('Activities 2'!L47-M50)>(M50*0.25),\"Error\",\"OK\"))","v":"Error"},null,{"$f":"IF(M49=M5,S54,S48)","v":{"v":24183,"d":"$24,183"}},null,"Less P&L Payments:",null,null,"-",{"$f":"SUMIFS($AI$11:$AI$60,$AD$11:$AD$60,\"P&L\",$AE$11:$AE$60,\"ARC\")","v":{"v":-24182.999999999996,"d":"(24,183.00)"}}]
[{"$nulls":12},2]
[{"$nulls":12},564,null,{"$f":"\"FYE \"&M5-1&\" P&L Payable @ 06/30/\"&$M$5-2000&\":\"","v":"FYE 2017 P&L Payable @ 06/30/18:"},{"$nulls":3},{"$f":"SUM(S48:S51)","v":0}]
["12)",null,{"$f":"\"Line 564 (Diocesan Assessments):  the Parish reported \"&TEXT('Activities 3'!L34,\"$#,##0\")&\" of expenses, \"&IF('Activities 3'!L34=M53,\"which is in agreement with Diocesan records.\",\"while Diocesan records indicate \"&TEXT(M53,\"$#,##0\")&\".  The difference is \"&TEXT(ABS('Activities 3'!L34-M53),\"$#,##0\")&\".\")","v":"Line 564 (Diocesan Assessments):  the Parish reported $0 of expenses, while Diocesan records indicate $42,000.  The difference is $42,000."},{"$nulls":7},{"$f":"IF('Activities 3'!L34=M53,\"OK\",\"Error\")","v":"Error"},null,{"$f":"S31","v":{"v":42000,"d":"$42,000"}}]
[{"$nulls":14},{"$f":"\"Total \"&$M$5&\" P&L Billed on 06/01/\"&$M$5-2000&\":\"","v":"Total 2018 P&L Billed on 06/01/18:"},null,null,"+",{"$f":"SUMIFS($AI$11:$AI$60,$AD$11:$AD$60,\"P&L\",$AE$11:$AE$60,\"ARB\")","v":{"v":24693,"d":"24,693.00"}}]
[]
["Schedule 8:",{"$nulls":11},"LY_300",null,{"$f":"\"P&L Balance at 06/30/\"&M5-2000&\":\"","v":"P&L Balance at 06/30/18:"},{"$nulls":3},{"$f":"SUM(S52:S55)","v":{"v":24693,"d":"$24,693.00"}}]
["13)",null,"Line 300 (Net Assets): the Parish reported 2018-2019 Ending New Assets totalling $0, while the Statement of Position submitted last year reports New Assets of $0. The difference is $0.",{"$nulls":7},{"$f":"IF(ABS('Sch. 8'!L46-M57)<1,\"OK\",\"Error\")","v":"Error"},null,{"$f":"X17","v":{"v":582712,"d":"$582,712"}}]
[]
[{"$nulls":14},"IMP Activity"]
["Disclosures:",{"$nulls":11},"Net Asset Auth?"]
["14)",null,{"$f":"IF(M61=TRUE,\"Adjustments were necessary to bring the Net Asset Roll-Forward into balance.  Pastor/Administrator Authorization is on file.\",IF(AND(AND(Disclosures!V16>=-2,Disclosures!V16<=2),AND(Disclosures!X16>=-2,Disclosures!X16<=2),AND(Disclosures!Z16>=-2,Disclosures!Z16<=2)),\"The Net Asset Roll-Forward is in balance.\",\"The Net Asset Roll-Forward is out of balance.  Please review, correct, and resubmit your statement.\"))","v":"The Net Asset Roll-Forward is in balance."},{"$nulls":7},{"$f":"IF(M61=TRUE,\"OK\",IF(AND(AND(Disclosures!V16>=-2,Disclosures!V16<=2),AND(Disclosures!X16>=-2,Disclosures!X16<=2),AND(Disclosures!Z16>=-2,Disclosures!Z16<=2)),\"OK\",\"Error\"))","v":"OK"},null,false,null,{"$f":"\"IMP Interest Revenue FYE 06/30/\"&$M$5-2000&\":\"","v":"IMP Interest Revenue FYE 06/30/18:"},{"$nulls":3},{"$f":"SUMIFS($AS$11:$AS$70,$AO$11:$AO$70,\"DEP\",$AR$11:$AR$70,\"I\")","v":0},{"$nulls":7},"20034",20034,"2018","ESA","ARC","17034ESA","11215","2017-11-20",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","ESA","ARC","17034ESA","11222","2017-12-15",{"v":-400,"d":"($400.00)"}]
[{"$nulls":14},{"$f":"\"IMP Deposit Balance @ 06/01/\"&$M$5-2000&\":\"","v":"IMP Deposit Balance @ 06/01/18:"},{"$nulls":3},{"$f":"SUMIFS($AS$11:$AS$70,$AO$11:$AO$70,\"DEP\",$AR$11:$AR$70,\"B\")","v":0},{"$nulls":7},"20034",20034,"2018","ESA","ARC","17034ESA","11228","2017-12-15",{"v":-400,"d":"($400.00)"}]
[null,null,{"$f":"\"Line 102 (Stipends Payable) reports $\"&TEXT(Position!F40,\"#,##0\")&\" while the Stipend bank account on Line 3 of Sch. 1 reports $\"&TEXT('Sch. 1'!J12,\"#,##0\")&\".  Why?\"","v":"Line 102 (Stipends Payable) reports $0 while the Stipend bank account on Line 3 of Sch. 1 reports $0.  Why?"},{"$nulls":23},"20034",20034,"2018","ESA","ARC","17034ESA","11264","2018-01-02",{"v":-400,"d":"($400.00)"}]
[{"$nulls":14},{"$f":"\"IMP Loan Balance @ 06/30/\"&$M$5-2000&\":\"","v":"IMP Loan Balance @ 06/30/18:"},{"$nulls":3},{"$f":"SUMIFS($AS$11:$AS$70,$AO$11:$AO$70,\"LOAN\",$AR$11:$AR$70,\"B\")","v":0},{"$nulls":7},"20034",20034,"2018","ESA","ARC","17034ESA","11275","2018-01-11",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","ESA","ARC","17034ESA","11290","2018-01-11",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","ESA","ARC","17034ESA","11306","2018-01-22",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","ESA","ARC","17034ESA","11326","2018-01-29",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","ESA","ARC","17034ESA","11346","2018-02-08",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","ESA","ARM","17034ESA","N/A","2018-02-16",{"v":-3200,"d":"($3,200.00)"}]
[{"$nulls":26},"20034",20034,"2018","ESA","ARM","17034ESA","N/A","2018-02-16",{"v":1800,"d":"$1,800.00"}]
[{"$nulls":26},"20034",20034,"2018","ESA","ARC","17034ESA","11442","2018-04-19",{"v":-2400,"d":"($2,400.00)"}]
[{"$nulls":26},"20034",20034,"2018","ESA","ARC","17034ESA","11456","2018-04-23",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","ESA","ARC","17034ESA","11462","2018-05-02",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","ESA","ARC","17034ESA","11475","2018-05-09",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","ESA","ARC","17034ESA","11489","2018-05-24",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","ESA","ARC","17034ESA","11498","2018-05-24",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","ESA","ARC","17034ESA","11507","2018-06-01",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","ESA","ARC","17034ESA","11512","2018-06-07",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","ESA","ARC","17034ESA","11531","2018-06-13",{"v":-276,"d":"($276.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","BB","N/A","N/A","2017-07-01",{"v":16536,"d":"$16,536.00"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","16034PL","11000","2017-07-03",{"v":-426,"d":"($426.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","Var","2017-07-03",{"v":-375,"d":"($375.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11019","2017-07-20",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11030","2017-07-28",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11036","2017-08-03",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11057","2017-08-28",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11112","2017-09-28",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11137","2017-10-13",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11149","2017-10-17",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11161","2017-11-01",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11176","2017-11-01",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11201","2017-11-14",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11189","2017-11-14",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11214","2017-11-20",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11227","2017-12-15",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11221","2017-12-15",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11263","2018-01-02",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11274","2018-01-11",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11289","2018-01-11",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11305","2018-01-22",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11325","2018-01-29",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11345","2018-02-08",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARM","17034PL","ADJ","2018-03-06",{"v":1801,"d":"$1,801.00"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11441","2018-04-19",{"v":-2400,"d":"($2,400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11455","2018-04-23",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11461","2018-05-02",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11474","2018-05-09",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11497","2018-05-24",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11488","2018-05-24",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARB","18034PL","N/A","2018-06-01",{"v":18194,"d":"$18,194.00"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11506","2018-06-01",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11511","2018-06-07",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11530","2018-06-13",{"v":-400,"d":"($400.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11541","2018-06-18",{"v":-600,"d":"($600.00)"}]
[{"$nulls":26},"20034",20034,"2018","P&L","ARC","17034PL","11548","2018-06-28",{"v":-600,"d":"($600.00)"}]

{"sheet":"Accounting_Review_2","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"merged":[[0,1,0,10],[1,1,1,10],[2,1,2,10]]}

{"sheet":"Adjustments","index":17,"n_rows":3,"n_cols":6,"rows_kept":3,"merged":[[2,9,6,9],[5,1,6,1],[5,7,6,7],[29,1,29,9],[30,1,30,9],[31,1,31,9],[32,1,32,9],[33,1,33,9],[34,1,34,9],[35,1,35,9]]}
[]
[]
[{"$nulls":5}," "]

{"sheet":"IMP_Interest","index":18,"n_rows":0,"n_cols":0,"rows_kept":0,"merged":[[0,11,5,11],[51,1,51,11],[52,1,52,11],[53,1,53,11],[54,1,54,11],[55,1,55,11],[56,1,56,11],[57,1,57,11],[58,1,58,11],[59,1,59,11]]}